1 Workbook_BeforeClose/vbaCodeCodeAddIn/ThisWorkbook/2/7
No Comments
2 Workbook_Open/vbaCodeCodeAddIn/ThisWorkbook/9/11
I had a lot of problems running this!!
The GoBack routine cannot work if the
workbooks aren't opened and that cannot
happen until after THIS sub has ended.
3 fncSetProjectByName/vbaCodeCodeAddIn/zmCodeCode/6/54
Return a project OBJECT.
4 subSetActiveProjectByName/vbaCodeCodeAddIn/zmCodeCode/60/37
Set the ACTIVE project.
Loop through the projects.
Assume that the information comes from the
populated list on frmCodeCode. That means the project
has to be there.
5 fncProjectExists/vbaCodeCodeAddIn/zmCodeCode/97/42
Does the project exist?
Optionally creaye one.
Loop through the projects.
6 subGoToProcedure/vbaCodeCodeAddIn/zmCodeCode/139/67
Go to a Procedure just given a NAME.
This will go to and SHOW in the CODE PANE the
*first* procedure found.
This will loop through the whole project set.
7 fncFormatCodeArray/vbaCodeCodeAddIn/zmCodeCode/206/59
Undent.
Zap Comment Lines.
Reduce double spaces to one.
Replace a lot of stuff with spaces.
Strip anything in double quotes
Top and Tail with spaces
8 subAddText/vbaCodeCodeAddIn/zmCodeCode/265/19
Add text to the end of a string array.
9 subProcedureCodeToListBox/vbaCodeCodeAddIn/zmCodeCode/284/74
Populate a list box with code for a procedure.
Looks through Project Set for Procedure Name.
10 fncBrowseDlg/vbaCodeCodeAddIn/zmCodeCode/358/32
Open the windows file dialog.
11 fncArrayBinarySearch/vbaCodeCodeAddIn/zmCodeCode/390/271
Do a binary search of an array for a string.
This was built for the Procedures array and so
is specific for that structure.
Return -1 if not found.
### Careful here because -1 is a bit incongruous really
because that's the value of True.
12 subLoadListBoxFromArray/vbaCodeCodeAddIn/zmCodeCode/661/66
Load an array to a ListBox.
This is an attempt at a general process.
This does NOT sort the array as
that is probably done before.
This does NOT check for Filters or Exceptions.
Assume a TWO dimensioned array.
13 subDeleteModule/vbaCodeCodeAddIn/zmCodeCode/727/38
No Comments
14 subInsertModule/vbaCodeCodeAddIn/zmCodeCode/765/32
No Comments
15 subAddProcedure/vbaCodeCodeAddIn/zmCodeCode/797/94
Add a procedure to a project/module.
16 fncSearchArray/vbaCodeCodeAddIn/zmCodeCode/891/83
Search through an array.
17 subGoTo/vbaCodeCodeAddIn/zmCodeCode/974/39
Go to a place and LOOP
through the projects to check names.
18 subGoToDirectly/vbaCodeCodeAddIn/zmCodeCode/1013/59
Go to a place directly WITHOUT looping
through the projects to check names.
19 fncGoTo/vbaCodeCodeAddIn/zmCodeCode/1072/150
Go to a place and LOOP
through the projects to check names.
20 fncShrinkArray/vbaCodeCodeAddIn/zmCodeCode/1222/158
Return an array with only populated Items.
This is to reduce ReDim overhead in loops.
Written specifically for multidim arrays
but I anticipate changing it to check
the dimensions later.
Assume that if the last element is populated then
the array doesn't need shrinking.
21 subSetBookMark/vbaCodeCodeAddIn/zmCodeCode/1380/8
No Comments
22 subToggleBookMark/vbaCodeCodeAddIn/zmCodeCode/1388/8
No Comments
23 subSetBreakpoint/vbaCodeCodeAddIn/zmCodeCode/1396/7
On Error Resume Next
24 subMoveToNextCapitol/vbaCodeCodeAddIn/zmCodeCode/1403/36
Move to next capitol on current line.
25 subBookMarkAndBreakpoint/vbaCodeCodeAddIn/zmCodeCode/1439/13
Working as of 20110423.
But how am I going to use it!?
26 subClearProcedureBookMarks/vbaCodeCodeAddIn/zmCodeCode/1452/62
Clear bookmarks for the current procedure.
27 fncGuessVarType/vbaCodeCodeAddIn/zmCodeCode/1514/163
Try to return a variable type
using the INI file.
28 subClearIW/vbaCodeCodeAddIn/zmCodeCode/1677/8
No Comments
29 subFindAndReplaceDQ/vbaCodeCodeAddIn/zmCodeCode/1685/127
Written specifically to replace...
If * = "" then
with
if LenB(*) = 0 then
30 subccSortDims/vbaCodeCodeAddIn/zmSorts/2/154
BATCH.
31 subccSortSelectedDims/vbaCodeCodeAddIn/zmSorts/156/119
SELECTION.
32 subSelectionSortStrings/vbaCodeCodeAddIn/zmSorts/275/55
Sort a SINGLE Dim array.
Not my code. Don't remember where from.
Apologies.
Working as of 20110423.
33 subSortTwoDimArray/vbaCodeCodeAddIn/zmSorts/330/116
Sort a STRING array with 2 dimensions.
Assume Sort on the 2nd Dimension.
Sorts only on ONE element.
A lot of code is from somewhere else.
Don't remember where from... Apologies.
34 subSortAcrossArray/vbaCodeCodeAddIn/zmSorts/446/60
Sort over all elements.
1) Put all elements in a line together in a new array.
2) Sort it.
3) Put elements back in original format.
35 subSortAcrossArrayInSelectedOrder/vbaCodeCodeAddIn/zmSorts/506/100
Sort over all elements in a specific order.
1) Put all elements in a line together
orderd as specified..
2) Sort it.
3) Put elements back in original format.
36 subMergeSort/vbaCodeCodeAddIn/zmSorts/606/89
http://www.vbforums.com/showthread.php?t=473677
37 subInsertionSort/vbaCodeCodeAddIn/zmSorts/695/36
http://www.vbforums.com/showthread.php?t=473677
38 subArrayMergeSort/vbaCodeCodeAddIn/zmSorts/731/200
http://www.vbforums.com/showthread.php?t=473677
39 subSortMultiElements/vbaCodeCodeAddIn/zmSorts/931/53
Sort an array with 2 dimensions.
Assume Sort on the 2nd Dimension
so assumes it IS a 2 Dim array.
Sort on more than one element.
40 subDumpCommandBars/vbaCodeCodeAddIn/zmDump/2/31
Write out all of the command bars
41 subDumpVBEWindows/vbaCodeCodeAddIn/zmDump/33/27
List some windows.
42 subDumpAddIns/vbaCodeCodeAddIn/zmDump/60/31
Dump a list of addins to the immediate window.
43 subDumpRefs/vbaCodeCodeAddIn/zmDump/91/50
Dump a list of references to the IMMEDIATE window.
44 subDumpRefsToExcelSheet/vbaCodeCodeAddIn/zmDump/141/81
Dump a list of references to a new excel sheet.
45 subDumpccProcListToExcelSheet/vbaCodeCodeAddIn/zmDump/222/166
Dump a list of Procedures to a Document.
This is essentially the same as subProcedureCode
but the list is put into a document.
Do not list procedures starting with TEST.
Assume Comments are directly after the heading
and argument list.
46 subDumpInfoToWord/vbaCodeCodeAddIn/zmDump/388/33
Dumps information on the VBComponents of the current
VBProject to the Word.
From "VBA Developer's Handbook"
by Ken Getz and Mike Gilbert.
Copyright 1997; Sybex, Inc. All rights reserved.
47 subDumpPropsToExcelSheet/vbaCodeCodeAddIn/zmDump/421/30
Dumps the property values of the specified VBComponent
48 subDumpListBoxToExcelSheet/vbaCodeCodeAddIn/zmDump/451/19
Dump a listbox to a sheet.
49 subDumpStringToExcelSheet/vbaCodeCodeAddIn/zmDump/470/75
Dump a string.
50 subDumpDictionaryToIW/vbaCodeCodeAddIn/zmDump/545/14
No Comments
51 subDumpExcelNamesToIW/vbaCodeCodeAddIn/zmDump/559/12
No Comments
52 subDumpAllProcsToExcelSheetWithHTML/vbaCodeCodeAddIn/zmDump/571/176
Dump a list of Procedures to a Document and
include HTML.
This is essentially the same as subProcedureCode
but the list is put into a document.
Do not list procedures starting with TEST.
Assume Comments are directly after the heading
and argument list.
Working as of 20110423.
53 subDumpActiveProjectProcsToExcelSheet/vbaCodeCodeAddIn/zmDump/747/177
Dump a list of Procedures to a Document.
This is essentially the same as subProcedureCode
but the list is put into a document.
Do not list procedures starting with TEST.
Assume Comments are directly after the heading
and argument list.
Working as of 20110423.
54 subDumpConditionalFormatting/vbaCodeCodeAddIn/zmDump/924/55
SNB
http://www.vbaexpress.com/forum/showthread.php?49652-Listing-Conditional-
Formatting-on-Separate-Sheet-or-Workbook
55 subDumpColWidths/vbaCodeCodeAddIn/zmDump/979/10
No Comments
56 subDumpConditions/vbaCodeCodeAddIn/zmDump/989/21
No Comments
57 subDumpLinks/vbaCodeCodeAddIn/zmDump/1010/74
http://access-excel.tips/find-external-links-broken-links/
58 linkStatusDescr/vbaCodeCodeAddIn/zmDump/1084/29
http://access-excel.tips/find-external-links-broken-links/
59 subccRemoveEndOfLineComment/vbaCodeCodeAddIn/zmUpdateLines/2/10
BATCH.
60 subccCommentDebugPrint/vbaCodeCodeAddIn/zmUpdateLines/12/8
BATCH.
61 subccDeleteDebugPrint/vbaCodeCodeAddIn/zmUpdateLines/20/8
BATCH.
62 subccCommentDebugCode/vbaCodeCodeAddIn/zmUpdateLines/28/8
BATCH.
63 subccDeleteLineLike/vbaCodeCodeAddIn/zmUpdateLines/36/8
BATCH.
64 subccCommentLineLike/vbaCodeCodeAddIn/zmUpdateLines/44/8
BATCH.
65 subccInsertTraceLines/vbaCodeCodeAddIn/zmUpdateLines/52/9
BATCH.
66 subccDeleteInserted/vbaCodeCodeAddIn/zmUpdateLines/61/8
BATCH.
67 subccDeleteStop/vbaCodeCodeAddIn/zmUpdateLines/69/8
BATCH.
68 subccDeleteDebugCode/vbaCodeCodeAddIn/zmUpdateLines/77/8
BATCH.
69 subccDoubleToSingleBlankLines/vbaCodeCodeAddIn/zmUpdateLines/85/8
BATCH.
70 subccReplaceLineLike/vbaCodeCodeAddIn/zmUpdateLines/93/8
BATCH.
71 subUpdateLines/vbaCodeCodeAddIn/zmUpdateLines/101/375
BATCH.
NO REPORT.
NO END MESSAGE.
72 subWhereAreWeP/vbaCodeCodeAddIn/zzmWhereAreWe/2/881
Return arrays with details of where the cursor is
and other information about the procedure.
BUT!!! If we are in a declaration then no procedure info
is returned.
73 subShortWhereAreWe/vbaCodeCodeAddIn/zzmWhereAreWe/883/17
Only in bookmarks.
74 fncShortWhereAreWe/vbaCodeCodeAddIn/zzmWhereAreWe/900/31
Return an array.
Make it the same size as the long one for consistency of
Item numbers.
75 subPrintWhereAreWeArray/vbaCodeCodeAddIn/zzmWhereAreWe/931/19
Dump the array to the immediate window.
76 subPrintWhereWeAre/vbaCodeCodeAddIn/zzmWhereAreWe/950/28
No Comments
77 subWhereAreWePX/vbaCodeCodeAddIn/zzmWhereAreWe/978/1514
Return arrays with details of where the cursor is
and other information about the procedure.
BUT!!! If we are in a declaration then no procedure info
is returned.
78 subccInsertErrorCodeAtLine/vbaCodeCodeAddIn/zmInsertErrorCodeAtLine/2/289
NOT BATCH.
NO REPORT.
NO END MESSAGE.
79 subccPrefixSuffixVariables/vbaCodeCodeAddIn/zmPrefixSuffixVariables/2/456
BATCH.
NO REPORT.
END MESSAGE.
80 subShutDownExcel/vbaCodeCodeAddIn/mappExcel/2/53
Save all workbooks and quit.
81 subWriteExcelReport/vbaCodeCodeAddIn/mappExcel/55/18
Write A report to an Excel Sheet.
82 subInsertExcelDT/vbaCodeCodeAddIn/mappExcel/73/7
Put the date and time in the active cell.
83 subSetExcelReportPoint/vbaCodeCodeAddIn/mappExcel/80/33
Optionally Add a sheet or move to the end.
Put the date and time in "A1".
Move down a row.
Default is to APPEND to the end
of the current sheet.
84 subWriteExcelRows/vbaCodeCodeAddIn/mappExcel/113/29
Write to an excel sheet along rows.
Assumes ...
Splits on ;
If there is a : uses the
85 subWriteExcelHeaders/vbaCodeCodeAddIn/mappExcel/142/31
Write to an excel sheet along rows.
Assumes ...
Splits on ;
If there is a : uses the
This will typically be used to write a HEADERS line.
86 subWriteExcel/vbaCodeCodeAddIn/mappExcel/173/101
Write to an excel sheet along rows.
87 subA1/vbaCodeCodeAddIn/mappExcel/274/4
No Comments
88 fncGetLastRow/vbaCodeCodeAddIn/mappExcel/278/28
Get the last row with data.
89 subArrayToSheet/vbaCodeCodeAddIn/mappExcel/306/29
Q&D!
90 fncInstrRev/vbaCodeCodeAddIn/mappExcel/335/6
This is so we can use INSTRREV in worksheet functions.
91 subSetExcelClassInstancing/vbaCodeCodeAddIn/mappExcel/341/4
No Comments
92 subTransposeRangeAdresses/vbaCodeCodeAddIn/mappExcel/345/35
Take a selected row range and produce formulae to = the values in a column.
Built to transpose the totals rows to go down for a summary.
93 subChangeVariableNames/vbaCodeCodeAddIn/mappExcel/380/17
This will change variable names between the hard
coded line limits.
94 subInsertA1/vbaCodeCodeAddIn/mappExcel/397/22
No Comments
95 fncInsertLine/vbaCodeCodeAddIn/mappExcel/419/91
Insert a new line into the current sheet and
return the cell.
96 subCopyFormulae/vbaCodeCodeAddIn/mappExcel/510/56
No Comments
97 MakeShortcut/vbaCodeCodeAddIn/mappExcel/566/40
Not mine... Can't remember where from.
98 subCreateDeskTopShortcut/vbaCodeCodeAddIn/mappExcel/606/21
99 subConvertLocalNamesToGlobal/vbaCodeCodeAddIn/mappExcel/627/33
No Comments
100 subConvertLocalNamesToGlobalA/vbaCodeCodeAddIn/mappExcel/660/46
No Comments
101 subtestsubClearCellsWithContent/vbaCodeCodeAddIn/mappExcel/706/3
No Comments
102 subClearCellsWithContent/vbaCodeCodeAddIn/mappExcel/709/45
Test for a string and if found clear the cell
contents.
Possible to test for partial or whole cell content
and exact match or not.
103 subChangeTo2DP/vbaCodeCodeAddIn/mappExcel/754/4
No Comments
104 subRealChangeTo2DP/vbaCodeCodeAddIn/mappExcel/758/64
Change numbers to real 2DP.
105 subRemoveFormattingOfTable/vbaCodeCodeAddIn/mappExcel/822/26
JKP!!
106 subtestfncRealRoundToDP/vbaCodeCodeAddIn/mappExcel/848/5
No Comments
107 fncRealRoundToDP/vbaCodeCodeAddIn/mappExcel/853/37
This is because Excel only looks at the next DP and doesn't
round "properly".
108 fncCellType/vbaCodeCodeAddIn/mappExcel/890/22
http://spreadsheetpage.com/index.php/tip/C32/P10/
John Walkbench.
Returns the cell type of the upper left
cell in a range
109 fncCellTypeN/vbaCodeCodeAddIn/mappExcel/912/28
Return a vbDataType long.
110 subIgnoreErrors/vbaCodeCodeAddIn/mappExcel/940/26
Remove all the little triangles and so on that
excel is trying to warn you about.
111 subRemoveAllErrorsFromRange/vbaCodeCodeAddIn/mappExcel/966/26
Remove all the little triangles and so on that
excel is trying to warn you about.
112 fncFindLastRow/vbaCodeCodeAddIn/mappExcel/992/9
No Comments
113 fncFindLastColumn/vbaCodeCodeAddIn/mappExcel/1001/10
No Comments
114 fncFindLastCell/vbaCodeCodeAddIn/mappExcel/1011/12
No Comments
115 subTestfncFindLastCell/vbaCodeCodeAddIn/mappExcel/1023/10
No Comments
116 subccShutDown/vbaCodeCodeAddIn/zmGeneric/10/13
Insert the date and time depending on application.
117 subInsertDT/vbaCodeCodeAddIn/zmGeneric/23/15
Insert the date and time depending on application.
118 subAddADoc/vbaCodeCodeAddIn/zmGeneric/38/33
Add a document or append to the
current one.
Depends on the application.
119 subWriteLines/vbaCodeCodeAddIn/zmGeneric/71/17
To write an array of LINES depending on the application and format.
120 subWriteHeaders/vbaCodeCodeAddIn/zmGeneric/88/17
To write an array of HEADERS depending on the application and format.
121 subCreateReport/vbaCodeCodeAddIn/zmGeneric/105/57
Create a report.
The code below can be altered to reflect different applications.
122 fncGetSavePath/vbaCodeCodeAddIn/zmGeneric/162/25
No Comments
123 fncGetApplFileName/vbaCodeCodeAddIn/zmGeneric/187/36
No Comments
124 subSaveRootFile/vbaCodeCodeAddIn/zmGeneric/223/21
No Comments
125 fncGetVBProjFileName/vbaCodeCodeAddIn/zmGeneric/244/26
No Comments
126 fncGetFileName/vbaCodeCodeAddIn/zmGeneric/270/27
Assume that the application.
has a NAME property.
127 fncValidDateString/vbaCodeCodeAddIn/zmGeneric/297/26
No Comments
128 subEnable/vbaCodeCodeAddIn/zmGeneric/323/26
Enable keys and menu options.
129 subDisable/vbaCodeCodeAddIn/zmGeneric/349/24
Disable keys and menu options
130 subEnableControl/vbaCodeCodeAddIn/zmGeneric/373/15
No Comments
131 subtestsubWhereAreWePX/vbaCodeCodeAddIn/amTerst/171/38
132 subtestsubWhereAreWeP/vbaCodeCodeAddIn/amTerst/209/33
133 subtestRun/vbaCodeCodeAddIn/amTerst/242/18
No Comments
134 subtestVS/vbaCodeCodeAddIn/amTerst/260/44
No Comments
135 subtestGetProcKind/vbaCodeCodeAddIn/amTerst/304/24
No Comments
136 subtestTrueFalse/vbaCodeCodeAddIn/amTerst/328/59
No Comments
137 subtestfncBinaryStringToDouble/vbaCodeCodeAddIn/amTerst/387/13
No Comments
138 subtestfncGuessVarType/vbaCodeCodeAddIn/amTerst/400/6
No Comments
139 subtestModuleType/vbaCodeCodeAddIn/amTerst/406/19
No Comments
140 subtestFilter/vbaCodeCodeAddIn/amTerst/425/12
No Comments
141 subtestTimingForInLineIfs/vbaCodeCodeAddIn/amTerst/437/38
No Comments
142 subtestfncIsKW/vbaCodeCodeAddIn/amTerst/475/31
No Comments
143 subtestfncGetAvailableItemsNames/vbaCodeCodeAddIn/amTerst/506/8
No Comments
144 subtestGetJoinedLines/vbaCodeCodeAddIn/amTerst/514/6
No Comments
145 subtestfncGetKeyWordList/vbaCodeCodeAddIn/amTerst/520/8
No Comments
146 subtestCreateINISection/vbaCodeCodeAddIn/amTerst/528/9
No Comments
147 subtestsubAddToKeyWordList/vbaCodeCodeAddIn/amTerst/537/15
No Comments
148 subtestClassScope/vbaCodeCodeAddIn/amTerst/552/9
No Comments
149 subtestClassScopeA/vbaCodeCodeAddIn/amTerst/561/4
No Comments
150 subtestfncIsLowerCase/vbaCodeCodeAddIn/amTerst/565/4
No Comments
151 subtestfncStripChrs/vbaCodeCodeAddIn/amTerst/569/146
No Comments
152 subEnd/vbaCodeCodeAddIn/amTerst/715/4
No Comments
153 subToggleProcHeadings/vbaCodeCodeAddIn/amTerst/719/5
() ' (Optional dummy As String)
() ' (Optional dummy As String)
*********************************************************************
154 subRealHideVBE/vbaCodeCodeAddIn/amTerst/724/4
No Comments
155 gggggggg/vbaCodeCodeAddIn/amTerst/728/4
No Comments
156 subtestIfStar/vbaCodeCodeAddIn/amTerst/732/11
No Comments
157 subtestCreateVBAProject/vbaCodeCodeAddIn/amTerst/743/26
No Comments
158 subtestfncGetINIFileName/vbaCodeCodeAddIn/amTerst/769/5
No Comments
159 Update_SmartIndenter_Tab_Width/vbaCodeCodeAddIn/amTerst/774/31
-------------------------------------------------------------------------------
Procedure : Update_SmartIndenter_Tab_Width
Author : Hartmut Gruenhagen
Date : 31-Jan-14
Purpose : In Office 2010/13 SmartIndentor fails to pick up the
VBA Editor tab width from the registry.
The procedure writes the VBA editor tab width into a
that Smart Indentor will then be able to read it.
-------------------------------------------------------------------------------
160 subccGoToBottomOfDimsAA/vbaCodeCodeAddIn/amTerst/805/55
NOT BATCH.
NO REPORT.
NO END MESSAGE.
161 fmt/vbaCodeCodeAddIn/amTerst/860/42
No Comments
162 toStr/vbaCodeCodeAddIn/amTerst/902/14
No Comments
163 subtestfncGetDeclarations/vbaCodeCodeAddIn/amTerst/916/8
No Comments
164 subtestsubSplitDeclarations/vbaCodeCodeAddIn/amTerst/924/5
No Comments
165 subtestStringTrueFalse/vbaCodeCodeAddIn/amTerst/929/25
No Comments
166 chkIndent_Change/vbaCodeCodeAddIn/frmCodeCode/70/21
No Comments
167 cmdCreateModule_Click/vbaCodeCodeAddIn/frmCodeCode/91/191
Use an unindeted node to create a module for a procedure.
168 cmdDown_Click/vbaCodeCodeAddIn/frmCodeCode/282/6
No Comments
169 cmdEditINIFile_Click/vbaCodeCodeAddIn/frmCodeCode/288/6
No Comments
170 cmdBrowse1_Click/vbaCodeCodeAddIn/frmCodeCode/294/25
No Comments
171 cmdRefreshForm_Click/vbaCodeCodeAddIn/frmCodeCode/319/12
No Comments
172 cmdWinMerge_Click/vbaCodeCodeAddIn/frmCodeCode/331/119
No Comments
173 cmdBrowse2_Click/vbaCodeCodeAddIn/frmCodeCode/450/25
No Comments
174 cmdExportFindAll_Click/vbaCodeCodeAddIn/frmCodeCode/475/70
Export to a CSV Text File.
175 cmdFindAll_Click/vbaCodeCodeAddIn/frmCodeCode/545/30
No Comments
176 cmdListSorOrdertDown_Click/vbaCodeCodeAddIn/frmCodeCode/575/6
No Comments
177 cmdListSorOrdertUp_Click/vbaCodeCodeAddIn/frmCodeCode/581/6
No Comments
178 cmdMinCentre_Click/vbaCodeCodeAddIn/frmCodeCode/587/20
No Comments
179 cmdTest_Click/vbaCodeCodeAddIn/frmCodeCode/607/7
This is to test code with the form showing.
180 cmdUp_Click/vbaCodeCodeAddIn/frmCodeCode/614/6
No Comments
181 cmdAllList_Click/vbaCodeCodeAddIn/frmCodeCode/620/6
No Comments
182 cmdAllModules_Click/vbaCodeCodeAddIn/frmCodeCode/626/8
No Comments
183 cmdAllProjects_Click/vbaCodeCodeAddIn/frmCodeCode/634/8
No Comments
184 cmdAllRun_Click/vbaCodeCodeAddIn/frmCodeCode/642/6
No Comments
185 cmdClearList_Click/vbaCodeCodeAddIn/frmCodeCode/648/6
No Comments
186 cmdClearModules_Click/vbaCodeCodeAddIn/frmCodeCode/654/7
No Comments
187 cmdClearProjects_Click/vbaCodeCodeAddIn/frmCodeCode/661/8
No Comments
188 cmdClearRun_Click/vbaCodeCodeAddIn/frmCodeCode/669/7
No Comments
189 lstFieldList_DblClick/vbaCodeCodeAddIn/frmCodeCode/676/15
Add to the sort order list.
Remove from the field list.
190 lstFindAll_DblClick/vbaCodeCodeAddIn/frmCodeCode/691/16
No Comments
191 lstListSorOrder_DblClick/vbaCodeCodeAddIn/frmCodeCode/707/14
Add to the field list.
192 lstNames_DblClick/vbaCodeCodeAddIn/frmCodeCode/721/17
Go To procedure double clicked.
193 lstRun_Change/vbaCodeCodeAddIn/frmCodeCode/738/35
No Comments
194 lstRun_DblClick/vbaCodeCodeAddIn/frmCodeCode/773/4
No Comments
195 subSetListBoxCounter/vbaCodeCodeAddIn/frmCodeCode/777/18
Reset the listbox counter.
196 subMoveListBoxItem/vbaCodeCodeAddIn/frmCodeCode/795/40
No checking is performed here for multicolumns so
it is assumed you know what you're doing!!
197 cmdGetBookMarks_Click/vbaCodeCodeAddIn/frmCodeCode/835/38
No Comments
198 cmdSaveBookMarkSet_Click/vbaCodeCodeAddIn/frmCodeCode/873/70
No Comments
199 lstBookMarks_DblClick/vbaCodeCodeAddIn/frmCodeCode/943/15
No Comments
200 cmdToggleBookmarkSet_Click/vbaCodeCodeAddIn/frmCodeCode/958/49
No Comments
201 cmdDeleteBookMarkSet_Click/vbaCodeCodeAddIn/frmCodeCode/1007/42
No Comments
202 subLoadBookMarkSetsToListBoxes/vbaCodeCodeAddIn/frmCodeCode/1049/48
No Comments
203 lstBookMarkSets_Click/vbaCodeCodeAddIn/frmCodeCode/1097/45
No Comments
204 cmdSaveRun_Click/vbaCodeCodeAddIn/frmCodeCode/1142/73
Save a set of Procedures to run to the INI file.
205 subLoadProcedureSetsToListBoxes/vbaCodeCodeAddIn/frmCodeCode/1215/37
No Comments
206 cmdDeleteProcedureSet_Click/vbaCodeCodeAddIn/frmCodeCode/1252/41
No Comments
207 cmdLoadProcedureSet_Click/vbaCodeCodeAddIn/frmCodeCode/1293/29
No Comments
208 lstProcedureSets_Click/vbaCodeCodeAddIn/frmCodeCode/1322/30
No Comments
209 subSetListBox/vbaCodeCodeAddIn/frmCodeCode/1352/45
Clear all or set all or count selected.
Set the numbers label.
210 scrbSyncScroll_Scroll/vbaCodeCodeAddIn/frmCodeCode/1397/33
This is the Scroll Bar Sync Scroll control.
211 cmdExportNode_Click/vbaCodeCodeAddIn/frmCodeCode/1430/66
No Comments
212 subGetNodeArray/vbaCodeCodeAddIn/frmCodeCode/1496/38
Recursively Return a string array a node and it's children
ready to be exported to a text file. , _
213 cmdReSort_Click/vbaCodeCodeAddIn/frmCodeCode/1534/109
Get the sort order fields from the listbox.
Get the field list from the INI file.
Loop through the field list and get the element numbers.
Get the Items from the list box.
Sort them.
Reload the list box.
Save the new Sort Order in the INI file.
214 cmdGetSelection_Click/vbaCodeCodeAddIn/frmCodeCode/1643/36
No Comments
215 cmdDeleteSnippet_Click/vbaCodeCodeAddIn/frmCodeCode/1679/25
No Comments
216 cmdSaveSnippet_Click/vbaCodeCodeAddIn/frmCodeCode/1704/14
No Comments
217 lstSnippets_Click/vbaCodeCodeAddIn/frmCodeCode/1718/17
No Comments
218 cmdInsertSnippet_Click/vbaCodeCodeAddIn/frmCodeCode/1735/17
No Comments
219 subloadSnippets/vbaCodeCodeAddIn/frmCodeCode/1752/35
No Comments
220 cmdMinMax_Click/vbaCodeCodeAddIn/frmCodeCode/1787/48
Min > Max > Run > Min.
221 lstProjects_Change/vbaCodeCodeAddIn/frmCodeCode/1835/89
No Comments
222 lstModules_Change/vbaCodeCodeAddIn/frmCodeCode/1924/62
No Comments
223 lstProcedures_Change/vbaCodeCodeAddIn/frmCodeCode/1986/10
No Comments
224 cmdRun_Click/vbaCodeCodeAddIn/frmCodeCode/1996/283
Create a new procedure from the selected
procedures and run it.
At the moment it is NOT deleted afterwards.
225 subMakeParent/vbaCodeCodeAddIn/frmCodeCode/2279/38
No Comments
226 subLoadItemsToRunListBoxFromArray/vbaCodeCodeAddIn/frmCodeCode/2317/126
Had to seperate this one out because og passing the
Add In Project but it's essentially the same
as subLoadItemsToListBoxFromArrays so see that
Proc for comments.
227 subLoadItemsToListBoxFromArrays/vbaCodeCodeAddIn/frmCodeCode/2443/218
Rewritten to be a bit general so we can use it
for each of the listboxes.
All of the Filter/Exceptions arrays are now reqired bu may be
unallocated.
228 tvCalled_Click/vbaCodeCodeAddIn/frmCodeCode/2661/4
No Comments
229 tvCalling_Click/vbaCodeCodeAddIn/frmCodeCode/2665/4
No Comments
230 UserForm_Activate/vbaCodeCodeAddIn/frmCodeCode/2669/8
No Comments
231 UserForm_KeyDown/vbaCodeCodeAddIn/frmCodeCode/2677/6
No Comments
232 UserForm_KeyUp/vbaCodeCodeAddIn/frmCodeCode/2683/10
No Comments
233 UserForm_Layout/vbaCodeCodeAddIn/frmCodeCode/2693/23
No Comments
234 UserForm_Terminate/vbaCodeCodeAddIn/frmCodeCode/2716/37
No Comments
235 fncCheckProjectFileNames/vbaCodeCodeAddIn/frmCodeCode/2753/31
No Comments
236 subCalledToTreeViewFromArrays/vbaCodeCodeAddIn/frmCodeCode/2784/374
Rewritten yet again!!!!
237 UserForm_KeyPress/vbaCodeCodeAddIn/frmCodeCode/3158/9
No Comments
238 fncGetVisibleLinesInListBox/vbaCodeCodeAddIn/frmCodeCode/3167/25
No Comments
239 subCallingToTreeViewFromArrays/vbaCodeCodeAddIn/frmCodeCode/3192/243
Rewritten yet again!!!!
240 subRecurseLoadCallingTV/vbaCodeCodeAddIn/frmCodeCode/3435/257
No Comments
241 tvCalled_DblClick/vbaCodeCodeAddIn/frmCodeCode/3692/256
Open the clicked procedure in a new window.
242 tvCalling_DblClick/vbaCodeCodeAddIn/frmCodeCode/3948/229
Open the clicked procedure in a new window.
243 UserForm_Initialize/vbaCodeCodeAddIn/frmCodeCode/4177/538
Load list boxes and so on.
Procedures with "subcc" are the ones
that can be "Run".
Note that they are EXCLUDED from the procedures list box.
244 AddrOf/vbaCodeCodeAddIn/basAddrOf/43/46
No Comments
245 UserForm_Initialize/vbaCodeCodeAddIn/frmVBEOnKey/46/14
No Comments
246 UserForm_Terminate/vbaCodeCodeAddIn/frmVBEOnKey/60/5
No Comments
247 StartIt/vbaCodeCodeAddIn/modExample/24/7
No Comments
248 StopIt/vbaCodeCodeAddIn/modExample/31/8
No Comments
249 Procedure1/vbaCodeCodeAddIn/modExample/39/7
No Comments
250 Procedure2/vbaCodeCodeAddIn/modExample/46/7
No Comments
251 VBEOnKey/vbaCodeCodeAddIn/modVBEOnKey/96/38
No Comments
252 HookKey/vbaCodeCodeAddIn/modVBEOnKey/134/29
No Comments
253 UnHookKey/vbaCodeCodeAddIn/modVBEOnKey/163/31
No Comments
254 UnHookAll/vbaCodeCodeAddIn/modVBEOnKey/194/22
No Comments
255 HookWindow/vbaCodeCodeAddIn/modVBEOnKey/216/25
No Comments
256 UnhookWindow/vbaCodeCodeAddIn/modVBEOnKey/241/21
No Comments
257 WindowProc/vbaCodeCodeAddIn/modVBEOnKey/262/60
No Comments
258 TimerCallback/vbaCodeCodeAddIn/modVBEOnKey/322/32
No Comments
259 LoWord/vbaCodeCodeAddIn/modVBEOnKey/354/16
No Comments
260 GetHookInfo/vbaCodeCodeAddIn/modVBEOnKey/370/24
No Comments
261 GetKeyCode/vbaCodeCodeAddIn/modVBEOnKey/394/50
No Comments
262 WindowProcAddress/vbaCodeCodeAddIn/modVBEOnKey/444/6
No Comments
263 TimerProcAddress/vbaCodeCodeAddIn/modVBEOnKey/450/4
No Comments
264 Long2Long/vbaCodeCodeAddIn/modVBEOnKey/454/9
No Comments
265 subUnNestX/vbaCodeCodeAddIn/zmUnIf/2/107
No Comments
266 subMultiUnIf/vbaCodeCodeAddIn/zmUnIf/109/10
No Comments
267 subUnIf/vbaCodeCodeAddIn/zmUnIf/119/26
Assume a "legal" IF statement.
Assume condition does not contain an IF.
Assumes we are on the sheet with the If.
268 fncGetPart/vbaCodeCodeAddIn/zmUnIf/145/47
No Comments
269 subSetUpVBOnKeys/vbaCodeCodeAddIn/zmSetupVBOnKeys/2/17
Set up OnKey Keys.
270 subccInsertAllDebugLines/vbaCodeCodeAddIn/zmInsertAllDeBugLines/2/130
BATCH.
NO REPORT.
END MESSAGE.
271 subccInsertSelectionDebug/vbaCodeCodeAddIn/zmInsertSelectionDebug/2/272
SELECTION.
NO REPORT.
NO END MESSAGE.
272 subccCloseOtherCodePanes/vbaCodeCodeAddIn/zmOtherccProcedures/2/29
PROJECT.
NO REPORT.
NO END MESSAGE.
273 subccCloseAllCodePanes/vbaCodeCodeAddIn/zmOtherccProcedures/31/20
PROJECT.
NO REPORT.
NO END MESSAGE.
274 subccGoToBottomOfDims/vbaCodeCodeAddIn/zmOtherccProcedures/51/44
NOT BATCH.
NO REPORT.
NO END MESSAGE.
275 subGoToTopOfGroup/vbaCodeCodeAddIn/zmOtherccProcedures/95/82
Go to the top of a ...
"Do", "While", "Select", "If","For","With".
276 subccInsertInverted/vbaCodeCodeAddIn/zmSwapCodeAround/2/92
SELECTION.
NO REPORT.
NO END MESSAGE.
277 fncSwapCodeLineAround/vbaCodeCodeAddIn/zmSwapCodeAround/94/29
Swap a LINE around...
to...
278 ListProcedureCallers/vbaCodeCodeAddIn/zmNotMine/2/33
http://dailydoseofexcel.com/archives/author/dick-kusleika/page/2/
279 fncExtractElement/vbaCodeCodeAddIn/zmNotMine/35/21
John Walkbench.
http://spreadsheetpage.com/index.php/site/tip/the_versatile_split_function/
Returns the nth element from a string,
using a specified separator character.
### Note that this does NOT miss out double quotes.
280 fncCountOccurrences/vbaCodeCodeAddIn/zmNotMine/56/14
John Walkbench.
http://spreadsheetpage.com/index.php/site/tip/the_versatile_split_function/
Returns the number of times substring appears in str
### Note that this does NOT miss out double quotes.
281 fncGetRandomStringFromMask/vbaCodeCodeAddIn/zmNotMine/70/66
http://www.devx.com/vb2themax/Tip/19355
Francesco Balena
generate a random string
282 subSetupExcelAddIn/vbaCodeCodeAddIn/zmNotMine/136/10
Example code to set an excel workbook as an add in.
SNB.
283 fncAM_I_Running_x64/vbaCodeCodeAddIn/zmNotMine/146/22
written by Jack in the UK for teh code cage
24th July 2014
feed - http://www.thecodecage.com/forumz/showthread.php?p=1055011207&posted=1#post1055011207
284 subccSplitColonLinesOnly/vbaCodeCodeAddIn/zmCodeFormatting/2/187
BATCH.
NO REPORT.
NO END MESSAGE.
285 subccSplitAllDims/vbaCodeCodeAddIn/zmCodeFormatting/189/148
NO REPORT.
NO END MESSAGE.
286 subccSplitDimsSelection/vbaCodeCodeAddIn/zmCodeFormatting/337/104
SELECTION.
NO REPORT.
NO END MESSAGE.
287 fncSplitDimLine/vbaCodeCodeAddIn/zmCodeFormatting/441/103
Return an array of Dims given a line of Dims
seperated by commas.
288 subccMoveEOLComments/vbaCodeCodeAddIn/zmCodeFormatting/544/175
BATCH.
NO REPORT.
NO END MESSAGE.
289 subccPutSpaceLineAboveComments/vbaCodeCodeAddIn/zmCodeFormatting/719/85
BATCH.
NO REPORT.
NO END MESSAGE.
290 subccInsertCommentAtTop/vbaCodeCodeAddIn/zmCodeFormatting/804/54
BATCH.
NO REPORT.
NO END MESSAGE.
291 subccInsertEndLine/vbaCodeCodeAddIn/zmCodeFormatting/858/61
BATCH.
NO REPORT.
NO END MESSAGE.
292 subccSplitSingleIfLines/vbaCodeCodeAddIn/zmCodeFormatting/919/176
BATCH.
NO REPORT.
NO END MESSAGE.
293 subccSplitLongCommentsSelected/vbaCodeCodeAddIn/zmCodeFormatting/1095/98
SELECTION.
NO REPORT.
NO END MESSAGE.
294 fncSplitSingleCommentLine/vbaCodeCodeAddIn/zmCodeFormatting/1193/132
Split comments on a line up into ~50 chr chunks.
### Note that blank lines are returned if any single piece
of text > 50.
This will apply mostly to links because we are calculating
a number of lines from the Len and then splitting on Space.
295 subccMoveDimsToTop/vbaCodeCodeAddIn/zmCodeFormatting/1325/80
BATCH.
NO REPORT.
NO END MESSAGE.
296 subccSplitParameters/vbaCodeCodeAddIn/zmCodeFormatting/1405/93
BATCH.
NO REPORT.
NO END MESSAGE.
297 subSplitNamedParameters/vbaCodeCodeAddIn/zmCodeFormatting/1498/159
BATCH.
NO REPORT.
NO END MESSAGE.
298 subccSplitAndsInSelection/vbaCodeCodeAddIn/zmCodeFormatting/1657/77
SELECTION.
NO REPORT.
NO END MESSAGE.
299 subccDeleteInBetweenLines/vbaCodeCodeAddIn/zmCodeFormatting/1734/85
Loop around a complete module from
the end of the declaration lines and
delete the blank lines in between procedures.
300 subSplitDeclarations/vbaCodeCodeAddIn/zmCodeFormatting/1819/180
BATCH.
NO REPORT.
NO END MESSAGE.
301 subCreateMenuButton/vbaCodeCodeAddIn/zmNotUsed/2/21
No Comments
302 fncGetVarValue/vbaCodeCodeAddIn/zmNotUsed/23/27
Iterate through the properties of the given
component till we get to the required property.
Assume we know we are not looking for an object.
303 subKeepVBEOnTop/vbaCodeCodeAddIn/zmNotUsed/50/5
No Comments
304 subRemoveVBEFromOnTop/vbaCodeCodeAddIn/zmNotUsed/55/6
No Comments
305 SplitEx/vbaCodeCodeAddIn/zmodSplitEx/4/175
====================================================================================
SplitEx
By Chip Pearson, chip@cpearson.com , www.cpearson.com, www.cpearson.com/Excel/Split.aspx
306 fncFindAll/vbaCodeCodeAddIn/zmFindAll/2/128
Find a text string across all projects.
Return a string array.
If none found return unallocated array.
Do this twice to count them because ReDim
won't work for multidim arrays.
307 fncGetVarValueA/vbaCodeCodeAddIn/zmGetFunctionsSubs/2/38
Iterate through the properties of the given
component till we get to the required property.
Assume we know we are not looking for an object.
308 fncGetProjectsCount/vbaCodeCodeAddIn/zmGetFunctionsSubs/40/28
Return a count of Projects.
Note that this is a "real" count and
not "zero" based.
309 fncGetModulesCount/vbaCodeCodeAddIn/zmGetFunctionsSubs/68/74
Return a count of Modules.
Default is over all Projects.
310 fncGetProcCount/vbaCodeCodeAddIn/zmGetFunctionsSubs/142/64
Return a count of Procs over all Projects.
Note that this is a "real" count and
not "zero" based.
This is to save the overhead of ReDimming all the time
and it's actually quite quick to go through the project
when you aren't doing much.
311 fncGetNewObjectName/vbaCodeCodeAddIn/zmGetFunctionsSubs/206/32
Return the New object name being set to a Class Object.
This is to check for NewObject.Property/Procedure.
spCodeArray should be the formatted code so that
it's possible to check for " " & NAme & " ".
Assumes a single line.
Return space if = New not found.
312 fncGetProjectsArray/vbaCodeCodeAddIn/zmGetFunctionsSubs/238/80
Load list of Projects to an array.
Goes through all the projects.
Returns a list of Projects.
313 fncGetModulesArray/vbaCodeCodeAddIn/zmGetFunctionsSubs/318/137
Load list of Modules to an array.
Goes through all the projects.
This is deliberate to keep the dependencies down.
Yes ... I know it's duplicate code to go through.
Returns an array of Modules with Project names.
314 fncGetVarTypeFromNumber/vbaCodeCodeAddIn/zmGetFunctionsSubs/455/72
Return a string variable type for a given type number.
315 fncGetIndent/vbaCodeCodeAddIn/zmGetFunctionsSubs/527/22
Return a string indent.
316 fncGetNextLineNumber/vbaCodeCodeAddIn/zmGetFunctionsSubs/549/29
Return the next complete line number.
Skip lines if there is a continuation chr.
317 fncGetFirstCodeLineNumberFromArray/vbaCodeCodeAddIn/zmGetFunctionsSubs/578/50
Assumes Dims are all in one place.
Also check for no Dims by checking for the header line.
318 fncGetSpacedOutLine/vbaCodeCodeAddIn/zmGetFunctionsSubs/628/47
Make the line uniform as possible.
Replace a lot of stuff with spaces.
This is to leave variables with a
space on either side even if they
are at the front or end of the line.
319 fncGetPrefix/vbaCodeCodeAddIn/zmGetFunctionsSubs/675/69
Return the lowercase prefix if a variable.
Assumes a naming Convention of...
prefixAaaaaAaaaa
Lower case prefix for type and scope.
Meaningful name with Uppercase Lower Case parts.
eg ilNumberOfCodeLines
i = Integer l = Local Number Of Code Lines.
320 fncGetCurrentProcName/vbaCodeCodeAddIn/zmGetFunctionsSubs/744/24
Return the Procedure name under the cursor.
321 fncGetElementFromListBox/vbaCodeCodeAddIn/zmGetFunctionsSubs/768/36
Return a unique array from a listbox.
Note that ipElementNumber is ZERO based.
322 fncGetUSedProcedureVariables/vbaCodeCodeAddIn/zmGetFunctionsSubs/804/257
Collect variables in a procedure together.
This EXCLUDES Dims.
Assumes a naming convention.
Drops everything beginning with a capitol letter.
Returns everything beginning with a lower case letter.
This will include Sub and Function calls as long
as they begin with lower case letters.
323 fncGetTotalDecLinesCount/vbaCodeCodeAddIn/zmGetFunctionsSubs/1061/40
Return total declarations line count for active project.
324 fncGetProcsDetailsArray/vbaCodeCodeAddIn/zmGetFunctionsSubs/1101/190
Load list of Procedures to a MULTIDIM array.
Goes through ALL the projects.
Returns a MULTIDIM Array.
325 fncGetParameters/vbaCodeCodeAddIn/zmGetFunctionsSubs/1291/60
Return an array of parameters given a CodeArray.
### Note that if there are no parameters an unallocated
array is returned.
The header line number is passed because we probably
have it already.
326 fncGetProjectDecVariables/vbaCodeCodeAddIn/zmGetFunctionsSubs/1351/61
This accepts a project OBJECT as the parameter
and doesn't bother with ALL or ACTIVE.
327 fncGetModuleDecVariables/vbaCodeCodeAddIn/zmGetFunctionsSubs/1412/233
Return an array of module level variables given a Project
name and Module name.
Assumes Variable declarations are not joined by ":".
328 fncGetVarArray/vbaCodeCodeAddIn/zmGetFunctionsSubs/1645/54
This basicically looks to see if an array
or a single line has been passed and then
calls fncGetLineArray appropriately.
329 fncGetLineArray/vbaCodeCodeAddIn/zmGetFunctionsSubs/1699/318
Return some line details in an array.
Originally just for Declaration lines so
is a near copy of fncGetDecLineType
... which is being phased out... with an added
parameter to say where the line comes from.
The parameter is mostly to deal with ENums and Types.
330 fncGetRandomString/vbaCodeCodeAddIn/zmGetFunctionsSubs/2017/72
Generate a random string.
331 fncGetFromBrackets/vbaCodeCodeAddIn/zmGetFunctionsSubs/2089/23
Return the text/number from within brackets as a string.
Do not alter the In string.
332 fncGetComponentTypeString/vbaCodeCodeAddIn/zmGetFunctionsSubs/2112/18
Return a string ginen a component type number.
333 fncGetProcTypeString/vbaCodeCodeAddIn/zmGetFunctionsSubs/2130/23
Return a string for a numeric ProcType.
334 fncGetAssociatedEXE/vbaCodeCodeAddIn/zmGetFunctionsSubs/2153/26
No Comments
335 fncGetUniqueProject/vbaCodeCodeAddIn/zmGetFunctionsSubs/2179/26
Return ProjectName(Project FileName) as seen
in the project explorer given a project
object.
336 fncGetProcCode/vbaCodeCodeAddIn/zmGetFunctionsSubs/2205/59
Return an array of procedure code
given...
Project Name(Project File Name)
Module Name
Procedure Name
Procedure Type
337 fncGetIncludedProjects/vbaCodeCodeAddIn/zmGetFunctionsSubs/2264/47
Return an array of not EXCLUDED projects.
338 fncGetIncludedModules/vbaCodeCodeAddIn/zmGetFunctionsSubs/2311/48
Return an array of not EXCLUDED modules.
339 fncGetIncludedProcedures/vbaCodeCodeAddIn/zmGetFunctionsSubs/2359/41
Return an array of not EXCLUDED Procedures.
340 fncGetExcludedProjects/vbaCodeCodeAddIn/zmGetFunctionsSubs/2400/31
Return an array of EXCLUDED Projects.
These are projects not loaded to
the list boxes for updating.
341 fncGetProceduresToRun/vbaCodeCodeAddIn/zmGetFunctionsSubs/2431/90
Return an array of procedures to run.
The UCase is because we get the add in name
from the INI file and we don't know what's there.
342 subGetCallsArray/vbaCodeCodeAddIn/zmGetFunctionsSubs/2521/206
"Return" an array showing which procs were
called where.
343 fncGetPrivateModuleStatus/vbaCodeCodeAddIn/zmGetFunctionsSubs/2727/43
Return TRUE if the module has
Option Private Module
in the declarations.
344 fncGetAddInProjectNamesArray/vbaCodeCodeAddIn/zmGetFunctionsSubs/2770/104
Return a LIST of Open and unlocked AddIn Projects.
345 fncGetCodeCodeProcNamesArray/vbaCodeCodeAddIn/zmGetFunctionsSubs/2874/82
Return a LIST of AddIn procedure names so we can check
to see if a project calls them.
346 fncGetAddInProcNamesDict/vbaCodeCodeAddIn/zmGetFunctionsSubs/2956/58
to see if a project calls them.
347 fncGetReferences/vbaCodeCodeAddIn/zmGetFunctionsSubs/3014/110
Return an array of referenced VBA projects.
348 fncGetNames/vbaCodeCodeAddIn/zmGetFunctionsSubs/3124/188
Return a set of names from an array.
Used for Declarations Parameters and Locals.
349 fncGetAvailableItemsNames/vbaCodeCodeAddIn/zmGetFunctionsSubs/3312/740
Return All available ITEM NAMES for a Procedure.
Assumes Variable declarations are not joined by ":".
350 fncGetNotDefined/vbaCodeCodeAddIn/zmGetFunctionsSubs/4052/359
This does similar stuff to XRef but
written as a function to return one of the
built arrays.
351 fncGetNotUsed/vbaCodeCodeAddIn/zmGetFunctionsSubs/4411/369
This does similar stuff to XRef but
written as a function to return one of the
built arrays.
352 fncGetBookMarks/vbaCodeCodeAddIn/zmGetFunctionsSubs/4780/139
Return an array of bookmark addresses...
slBookMarks(lnglN, 0) = lnglLineArray(lnglN)
slBookMarks(lnglN, 1) = slModuleNameArray(lnglN)
slBookMarks(lnglN, 2) = slProjectArray(lnglN)
slBookMarks(lnglN, 3) = slUniqueProjectArray(lnglN)
slBookMarks(lnglN, 4) = slProcedureArray(lnglN)
slBookMarks(lnglN, 5) = Actual Line
353 fncGetDeclarations/vbaCodeCodeAddIn/zmGetFunctionsSubs/4919/25
No Comments
354 fncStripDoubleSpaces/vbaCodeCodeAddIn/zmStringFunctions/2/27
Remove double spaces ONLY.
355 fncInstrExA/vbaCodeCodeAddIn/zmStringFunctions/29/83
Do an Instr but exclude anything in Double
Quotes brackets or after a comment character.
356 fncInstrExDQ/vbaCodeCodeAddIn/zmStringFunctions/112/83
Do an instr but miss out stuff in double quotes.
### Note.
It is not *generally* possible to have a string with
an odd number of double quotes.
It can happen though after a split(Line,":") with a : inside
of DQuotes and if deliberateley inserted into a
string'using chr(34).
357 fncGetArgDQ/vbaCodeCodeAddIn/zmStringFunctions/195/59
Return the argument number specified from a string
but not if in DQs.
### Note.. Does NOT return an error!
### This was meant to skip double quotes.
### Not working/finished yet.
358 fncStripString/vbaCodeCodeAddIn/zmStringFunctions/254/76
Collapse spaces.
Disseapear Double Quotes.
Strips comments from the end.
### Note it is possible to have a line with one "
This occured after a split(Line,":") with a : inside of DQuotes.
Amended to strip # as well for comditional compilations.
359 fncStripSpacesCommentsDQuotes/vbaCodeCodeAddIn/zmStringFunctions/330/76
Collapse spaces.
Disseapear Double Quotes.
Strips comments from the end.
### Note it is possible to have a line with one "
This occured after a split(Line,":") with a : inside of DQuotes.
Amended to strip # as well for comditional compilations.
360 fncStripBadFileNameChrs/vbaCodeCodeAddIn/zmStringFunctions/406/35
Replace Bad File Name chrs.
361 fncStripDQs/vbaCodeCodeAddIn/zmStringFunctions/441/46
Disseapears Double Quotes and
anything in between.
362 fncStripBrackets/vbaCodeCodeAddIn/zmStringFunctions/487/34
Delete ( ) and anything in between.
363 fncIsUpper/vbaCodeCodeAddIn/zmStringFunctions/521/9
Return True if parameter is UPPER case.
364 fncIsLower/vbaCodeCodeAddIn/zmStringFunctions/530/13
Return True if parameter is LOWER case.
365 fncIsAllLowerChrs/vbaCodeCodeAddIn/zmStringFunctions/543/41
Return True if parameter CHRS are LOWER case.
366 fncStartsWithCapitol/vbaCodeCodeAddIn/zmStringFunctions/584/20
Return True if parameter Starts with Ucase letter.
367 fncIsExpression/vbaCodeCodeAddIn/zmStringFunctions/604/25
Return true if an operator is found in the
string outside of DQs.
368 fncSplitName/vbaCodeCodeAddIn/zmStringFunctions/629/50
Will split a name up into chunks at every capitol
letter.
369 fncVarPos/vbaCodeCodeAddIn/zmStringFunctions/679/80
Do an INSTR for a Variable and return the start position
of the variable in the line.
Test for chr number and _ on either side of the
found pos.
Skip inside DQs.
370 fncReplace/vbaCodeCodeAddIn/zmStringFunctions/759/70
This is to replace the internal replace function.
The internal replace will return a string with
the left part up to Start chopped off if
a Start is given.
371 fncRemoveTrailingNumbers/vbaCodeCodeAddIn/zmStringFunctions/829/23
Remove trailing numbers.
Written so that variables like S1 and L2 are
accounted for in insertdims.
372 fncOldSplitBrackets/vbaCodeCodeAddIn/zmStringFunctions/852/46
Return an array with...
A File Name from within brackets.
A Project name from outside the brackets.
373 fncSplitProjectString/vbaCodeCodeAddIn/zmStringFunctions/898/44
Return an array with...
A File Name from within brackets.
A Project name from outside the brackets.
374 fncYesNo/vbaCodeCodeAddIn/zmStringFunctions/942/34
Return True or False for ...
Yes/No/Ja/Oui/Non/Nein/Nee/Si/Non/True/False/Numeric.
This is here because I found myself writing the case out
many times.
375 fncTrimNull/vbaCodeCodeAddIn/zmStringFunctions/976/13
No Comments
376 fncQuoteText/vbaCodeCodeAddIn/zmStringFunctions/989/60
Return the text bracketed by spChr.
This is nominally a double quote but can
be anything... single quote, bracket and so on.
377 fncStripSpaces/vbaCodeCodeAddIn/zmStringFunctions/1049/40
Collapse spaces.
378 fncStripPrefix/vbaCodeCodeAddIn/zmStringFunctions/1089/25
No Comments
379 fncProper/vbaCodeCodeAddIn/zmStringFunctions/1114/23
Capitalize the first letter.
380 fncGetFirstWord/vbaCodeCodeAddIn/zmStringFunctions/1137/13
No Comments
381 fncBinaryStringToDouble/vbaCodeCodeAddIn/zmStringFunctions/1150/25
No Comments
382 subtestfncStripNonAlpha/vbaCodeCodeAddIn/zmStringFunctions/1175/4
No Comments
383 fncStripNonAlpha/vbaCodeCodeAddIn/zmStringFunctions/1179/58
Delete non alpha chrs.
Originally built for testing for KeyWords.
384 fncStripChrs/vbaCodeCodeAddIn/zmStringFunctions/1237/73
Strip a list of given chrs from a string.
Made for multilinguality... ex Arabic.
Assumes each chr is just that. a single chr
that can be picked up with the MID$ function.
This means that different forms of the same chr
need to be listed... ex Aa.
385 fncStripChrsEx/vbaCodeCodeAddIn/zmStringFunctions/1310/125
Strip a list of given chrs from a string.
Skip anything in the ChrPair sets.
386 fncReadINIValue/vbaCodeCodeAddIn/zmINI/2/76
Read from the INI file.
387 fncWriteINIValue/vbaCodeCodeAddIn/zmINI/78/64
Write to the INI file.
388 B_subccSaveCodeSnippet/vbaCodeCodeAddIn/zmINI/142/8
This is purely and solely to include the sub in the list of CC
procedures.
389 subSaveCodeSnippet/vbaCodeCodeAddIn/zmINI/150/60
SELECTION.
390 subInsertCodeSnippet/vbaCodeCodeAddIn/zmINI/210/33
Insert a Named code snippet from the INI file.
391 fncGetCompleteSection/vbaCodeCodeAddIn/zmINI/243/103
Return an array of all items in a section.
Array ( n )
392 fncGetAllSections/vbaCodeCodeAddIn/zmINI/346/35
Return an array of all section names in the
INI file.
393 fncGetINIFileName/vbaCodeCodeAddIn/zmINI/381/31
### I'm dropping this.
It seems to me that if the user changes the name of the ADD IN
it's pretty well all bets are off.
394 fncGetSectionArray/vbaCodeCodeAddIn/zmINI/412/59
Return an array of a section.
395 subDeleteCodeSnippet/vbaCodeCodeAddIn/zmINI/471/26
Delete a code snippet from the INI file.
396 subDeleteProcedureSet/vbaCodeCodeAddIn/zmINI/497/24
Delete a code snippet from the INI file.
397 subInsertBookMarkSet/vbaCodeCodeAddIn/zmINI/521/19
Save a BOOKMARK SET to the INI file.
398 subDeleteBookMarkSet/vbaCodeCodeAddIn/zmINI/540/21
Delete a bookmark from the INI file.
399 subEditINIFile/vbaCodeCodeAddIn/zmINI/561/20
No Comments
400 fncYesNoAsk/vbaCodeCodeAddIn/zmINI/581/48
Alternative to fncYesNo.
Adds "Ask" to the options/
Return True or False for ...
Yes/No/Ja/Oui/Non/Nein/Nee/Si/Non/True/False/Numeric.
This is here because I found myself writing the case out
many times.
401 subMakeParent/vbaCodeCodeAddIn/frmInsertDebugOptions/13/43
No Comments
402 UserForm_Terminate/vbaCodeCodeAddIn/frmInsertDebugOptions/56/8
No Comments
403 cmdCancel_Click/vbaCodeCodeAddIn/frmInsertDebugOptions/64/4
No Comments
404 subUpdateINI/vbaCodeCodeAddIn/frmInsertDebugOptions/68/20
Update the INI File.
405 cmdOK_Click/vbaCodeCodeAddIn/frmInsertDebugOptions/88/17
Get out.
406 UserForm_Initialize/vbaCodeCodeAddIn/frmInsertDebugOptions/105/33
No Comments
407 subccInsertTimingCodeAtLine/vbaCodeCodeAddIn/zmInsertTimingCode/2/225
NOT BATCH.
NO REPORT.
NO END MESSAGE.
408 subccInsertTimingCodeInProc/vbaCodeCodeAddIn/zmInsertTimingCode/227/240
BATCH.
NO REPORT.
NO END MESSAGE.
409 subccSetToNothing/vbaCodeCodeAddIn/zmSetToNothing/2/105
BATCH.
NO REPORT.
NO END MESSAGE.
410 subccSetolWAWObjectsToNothing/vbaCodeCodeAddIn/zmSetToNothing/107/132
BATCH.
NO REPORT.
NO END MESSAGE.
411 subExportAllModules/vbaCodeCodeAddIn/zmExportImportAll/2/128
EXPORT All modules to a specified
Folder.
NO REPORT.
END MESSAGE.
412 subImportAllModules/vbaCodeCodeAddIn/zmExportImportAll/130/111
IMPORT specified modules from a specified
Folder.
NO REPORT.
END MESSAGE.
413 subExportProjectModulesToOneTextFile/vbaCodeCodeAddIn/zmExportImportAll/241/153
EXPORT All modules in a specified PROJECT
To a single text file.
NO REPORT.
END MESSAGE.
414 subShutDownAccess/vbaCodeCodeAddIn/mappAccess/2/4
No Comments
415 subSetAccessReportPoint/vbaCodeCodeAddIn/mappAccess/6/4
No Comments
416 subWriteAccessReport/vbaCodeCodeAddIn/mappAccess/10/8
No Comments
417 subInsertAccessDT/vbaCodeCodeAddIn/mappAccess/18/4
No Comments
418 subWriteAccessRows/vbaCodeCodeAddIn/mappAccess/22/4
No Comments
419 subWriteAccessHeaders/vbaCodeCodeAddIn/mappAccess/26/4
No Comments
420 subWriteAccess/vbaCodeCodeAddIn/mappAccess/30/6
No Comments
421 subArrayToDataBase/vbaCodeCodeAddIn/mappAccess/36/11
Q&D!
422 subShutDownWord/vbaCodeCodeAddIn/mappWord/2/9
Save all documents and quit.
423 subWriteWordReport/vbaCodeCodeAddIn/mappWord/11/18
Write A report to an Word Document.
424 subInsertWordDT/vbaCodeCodeAddIn/mappWord/29/7
Put the date and time in the active Document.
425 subSetWordReportPoint/vbaCodeCodeAddIn/mappWord/36/33
Optionally Add a document or move to the end.
Put the date and time in "A1".
Move down a row.
Default is to APPEND to the end
of the current sheet.
426 subWriteWordRows/vbaCodeCodeAddIn/mappWord/69/29
Write to an Word Table along rows.
Assumes ...
Splits on ;
If there is a : uses the
427 subWriteWordHeaders/vbaCodeCodeAddIn/mappWord/98/31
Write to an Word table along rows.
Assumes ...
Splits on ;
If there is a : uses the
This will typically be used to write a HEADERS line.
428 subWriteWord/vbaCodeCodeAddIn/mappWord/129/101
Write to an Word table along rows.
429 fncCloseAllWordDocs/vbaCodeCodeAddIn/mappWord/230/67
Helen Feddema.
http://www.helenfeddema.com/
430 subtestRegistryCode/vbaCodeCodeAddIn/zmRegistry/22/24
No Comments
431 fncLoadFromRegistry/vbaCodeCodeAddIn/zmRegistry/46/47
Uses the built in VBA functions.
432 subDeleteFromRegistry/vbaCodeCodeAddIn/zmRegistry/93/9
No Comments
433 subSaveToRegistry/vbaCodeCodeAddIn/zmRegistry/102/41
Uses the built in VBA functions.
434 fncGetAllSettings/vbaCodeCodeAddIn/zmRegistry/143/9
No Comments
435 subtestfncGetCommandLine/vbaCodeCodeAddIn/zmGetCommandLine/40/8
No Comments
436 fncGetCommandLineArray/vbaCodeCodeAddIn/zmGetCommandLine/48/81
Return an array of Switches & Values.
437 fncGetCommandLineText/vbaCodeCodeAddIn/zmGetCommandLine/129/67
Return the command line Switches & Values.
438 subFileSystemObject/vbaCodeCodeAddIn/zmFSOCode/2/210
This is just to copy code from.
It is NOT MEANT TO BE a working
procedure and will fail if run.
439 subWaitTillWorkBooksAreOpen/vbaCodeCodeAddIn/mGoBack/2/28
This is to try and go back once workbooks are opened!
This is recursive!
440 subGoBack/vbaCodeCodeAddIn/mGoBack/30/95
Go back to, mark and breakpoint the line set
by A_subccRememberLine.
441 subRememberLine/vbaCodeCodeAddIn/mGoBack/125/17
Set a line to go back to when opening.
442 fncGenerateGoToLine/vbaCodeCodeAddIn/mGoBack/142/58
Generate a line of code to go to the current line.
This is mostly for starting up from the last position.
443 subccBackMeUp/vbaCodeCodeAddIn/zmStandAloneBackup/52/25
Backup the current project.
444 subSaveNewVersion/vbaCodeCodeAddIn/zmStandAloneBackup/77/16
Run the REAL savenewversion procedure
with filenames set up.
If used, these must be set up womanually.
445 subSaveMe/vbaCodeCodeAddIn/zmStandAloneBackup/93/122
Save Current Project.
446 subRealBackMeUp/vbaCodeCodeAddIn/zmStandAloneBackup/215/279
##################################################################
447 subRealSaveNewVersion/vbaCodeCodeAddIn/zmStandAloneBackup/494/278
##################################################################
448 fncGetVNumber/vbaCodeCodeAddIn/zmStandAloneBackup/772/42
Pick out the first number from the END
of a filename.
No Number return -1.
Assumes one number.
449 fncGetRootFilName/vbaCodeCodeAddIn/zmStandAloneBackup/814/27
Return the bit IN FRONT of the number.
Assumes ONE number.
Assumes the ROOT is at the FRONT of the number.
450 fncGetFileName/vbaCodeCodeAddIn/zmStandAloneBackup/841/27
Assume that the application.
has a NAME property.
451 fncTrimNull/vbaCodeCodeAddIn/zmStandAloneBackup/868/13
No Comments
452 fncGetSavePath/vbaCodeCodeAddIn/zmStandAloneBackup/881/23
No Comments
453 subMsgBox/vbaCodeCodeAddIn/zmStandAloneBackup/904/42
This is to run a form to display a message.
454 fncInputBox/vbaCodeCodeAddIn/zmStandAloneBackup/946/40
No Comments
455 fncGetAssociatedEXE/vbaCodeCodeAddIn/zmStandAloneBackup/986/26
No Comments
456 subRealMsgBox/vbaCodeCodeAddIn/zmStandAloneBackup/1012/28
This is to run a form to display a message.
457 subInsertComments/vbaCodeCodeAddIn/zmInsertComments/2/10
Insert comments at the current line.
458 subMakeParent/vbaCodeCodeAddIn/frmInsertComments/14/39
No Comments
459 txtNumChrs_Change/vbaCodeCodeAddIn/frmInsertComments/53/3
No Comments
460 UserForm_Terminate/vbaCodeCodeAddIn/frmInsertComments/56/8
No Comments
461 cmdCancel_Click/vbaCodeCodeAddIn/frmInsertComments/64/4
No Comments
462 cmdInsert_Click/vbaCodeCodeAddIn/frmInsertComments/68/182
Insert text as comments from a text box.
463 UserForm_Initialize/vbaCodeCodeAddIn/frmInsertComments/250/32
No Comments
464 cmdClose_Click/vbaCodeCodeAddIn/frmProcedureCode/15/8
No Comments
465 makeNewInstance/vbaCodeCodeAddIn/frmProcedureCode/23/19
No Comments
466 UserForm_Initialize/vbaCodeCodeAddIn/frmProcedureCode/42/8
No Comments
467 subMakeParent/vbaCodeCodeAddIn/frmProcedureCode/50/37
No Comments
468 UserForm_Terminate/vbaCodeCodeAddIn/frmProcedureCode/87/8
No Comments
469 UserForm_QueryClose/vbaCodeCodeAddIn/frmProcedureCode/95/8
No Comments
470 LineNumber/vbaCodeCodeAddIn/frmProcedureCode/103/6
No Comments
471 LineNumber/vbaCodeCodeAddIn/frmProcedureCode/109/6
No Comments
472 Module/vbaCodeCodeAddIn/frmProcedureCode/115/6
No Comments
473 Module/vbaCodeCodeAddIn/frmProcedureCode/121/6
No Comments
474 Project/vbaCodeCodeAddIn/frmProcedureCode/127/6
No Comments
475 Project/vbaCodeCodeAddIn/frmProcedureCode/133/7
No Comments
476 subSetReferences/vbaCodeCodeAddIn/zmSetReferences/2/181
These items MUST be referenced.
1 The VBIDE.... Name = VBIDE
In order to reference the references.
2 Scripting runtime.... Name = Scripting
For File/Folder actions.. exists/create etc.
477 cmdClear_Click/vbaCodeCodeAddIn/frmMZVariables/11/15
No Comments
478 cmdDelete_Click/vbaCodeCodeAddIn/frmMZVariables/26/85
No Comments
479 cmdGoToProcedure_Click/vbaCodeCodeAddIn/frmMZVariables/111/18
No Comments
480 lstNotUsed_DblClick/vbaCodeCodeAddIn/frmMZVariables/129/9
No Comments
481 UserForm_Initialize/vbaCodeCodeAddIn/frmMZVariables/138/8
No Comments
482 subMakeParent/vbaCodeCodeAddIn/frmMZVariables/146/38
No Comments
483 UserForm_Terminate/vbaCodeCodeAddIn/frmMZVariables/184/8
No Comments
484 subLoadListBox/vbaCodeCodeAddIn/frmMZVariables/192/135
485 fncBrowseDlg/vbaCodeCodeAddIn/frmMZVariables/327/29
Open the windows file dialog.
486 fncSplitProjectString/vbaCodeCodeAddIn/frmMZVariables/356/44
Return an array with...
A File Name from within brackets.
A Project name from outside the brackets.
487 fncGetUniqueProject/vbaCodeCodeAddIn/frmMZVariables/400/26
Return ProjectName(Project FileName) as seen
in the project explorer given a project
object.
488 subGoToProcedure/vbaCodeCodeAddIn/frmMZVariables/426/78
Go to a Procedure.
This will loop through the whole project set.
489 fncJoinLines/vbaCodeCodeAddIn/zmJoinLines/2/142
NON Recursively Join up the lines that have underscores at the end.
Return the Line.
Go back up if we are in the middle of a continuation line set.
Optionally leave the underscores in or remove them.
Default is to remove them.
Strip EOL comment.
490 fncJoinLinesA/vbaCodeCodeAddIn/zmJoinLines/144/157
Alternative to and practically the same as fncJoinLines.
This version returns an array though rather than use the
function parameters.
491 fncGetJoinedLines/vbaCodeCodeAddIn/zmJoinLines/301/57
Return an array of joined lines.
Skip comments and blank lines.
492 fncGetJoinedLineFromCode/vbaCodeCodeAddIn/zmJoinLines/358/11
This will return a joined line from the code rather than
from an array.
493 subccXRefProcedure/vbaCodeCodeAddIn/zmXRefProcedure/2/588
NOT BATCH.
REPORT.
END MESSAGE.
494 subccInsertDims/vbaCodeCodeAddIn/zmInserDims/2/496
BATCH.
REPORT.
END MESSAGE.
495 subtestfrmMsgBox/vbaCodeCodeAddIn/zmMsgBox/2/11
No Comments
496 subtestsubMsgBox/vbaCodeCodeAddIn/zmMsgBox/13/6
No Comments
497 subEndMessage/vbaCodeCodeAddIn/zmMsgBox/19/17
ONLY Tell that we're Done.
498 subMsgBox/vbaCodeCodeAddIn/zmMsgBox/36/42
This is to run a form to display a message.
499 fncMsgBox/vbaCodeCodeAddIn/zmMsgBox/78/45
This is to run a form to display a message.
500 subRealMsgBox/vbaCodeCodeAddIn/zmMsgBox/123/26
This is to run a form to display a message.
501 fncRealMsgBox/vbaCodeCodeAddIn/zmMsgBox/149/24
No Comments
502 cmdCancel_Click/vbaCodeCodeAddIn/frmMsgBox/15/7
No Comments
503 cmdNo_Click/vbaCodeCodeAddIn/frmMsgBox/22/5
No Comments
504 cmdOK_Click/vbaCodeCodeAddIn/frmMsgBox/27/5
No Comments
505 cmdOK_KeyPress/vbaCodeCodeAddIn/frmMsgBox/32/6
No Comments
506 cmdYes_Click/vbaCodeCodeAddIn/frmMsgBox/38/5
No Comments
507 UserForm_Activate/vbaCodeCodeAddIn/frmMsgBox/43/7
No Comments
508 UserForm_Initialize/vbaCodeCodeAddIn/frmMsgBox/50/10
No Comments
509 subMakeParent/vbaCodeCodeAddIn/frmMsgBox/60/38
No Comments
510 UserForm_Terminate/vbaCodeCodeAddIn/frmMsgBox/98/8
No Comments
511 Answer/vbaCodeCodeAddIn/frmMsgBox/106/5
No Comments
512 Answer/vbaCodeCodeAddIn/frmMsgBox/111/5
No Comments
513 Title/vbaCodeCodeAddIn/frmMsgBox/116/6
No Comments
514 SetButtons/vbaCodeCodeAddIn/frmMsgBox/122/21
No Comments
515 UserForm_QueryClose/vbaCodeCodeAddIn/frmMsgBox/143/12
No Comments
516 subccCleanProcedure/vbaCodeCodeAddIn/zmCleanProcedure/2/354
BATCH.
REPORT.
END MESSAGE.
517 fncGetUniqueProject/vbaCodeCodeAddIn/cWhereAreWe/58/31
Return ProjectName(Project FileName) as seen
in the project explorer given a project
object.
518 fncIsArrayAllocated/vbaCodeCodeAddIn/cWhereAreWe/89/51
Chip Pearson.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
IsArrayAllocated
Returns TRUE if the array is allocated (either a static array or a dynamic array that has been
sized with Redim) or FALSE if the array is not allocated (a dynamic that has not yet
been sized with Redim, or a dynamic array that has been Erased). Static arrays are always
allocated.
519 fncJoinLines/vbaCodeCodeAddIn/cWhereAreWe/140/113
NON Recursively Join up the lines that have underscores at the end.
Return the Line.
Go back up if we are in the middle of a continuation line set.
Optionally leave the underscores in or remove them.
Default is to remove them.
Strip EOL comment.
520 fncGetParameters/vbaCodeCodeAddIn/cWhereAreWe/253/60
Return an array of parameters given a CodeArray.
### Note that if there are no parameters an unallocated
array is returned.
The header line number is passed because we probably
have it already.
521 Class_Initialize/vbaCodeCodeAddIn/cWhereAreWe/313/641
No Comments
522 ArrayProcedureHeaderLineInProcBodyLine/vbaCodeCodeAddIn/cWhereAreWe/954/8
No Comments
523 Parameters/vbaCodeCodeAddIn/cWhereAreWe/962/4
No Comments
524 ModuleStartOfCode/vbaCodeCodeAddIn/cWhereAreWe/966/4
No Comments
525 ModuleStartOfDims/vbaCodeCodeAddIn/cWhereAreWe/970/4
No Comments
526 ModuleEndOfDimsP1/vbaCodeCodeAddIn/cWhereAreWe/974/4
No Comments
527 ArrayEndOfDimsP1/vbaCodeCodeAddIn/cWhereAreWe/978/4
No Comments
528 ModuleEndProcedureLineNumber/vbaCodeCodeAddIn/cWhereAreWe/982/4
No Comments
529 ArrayEndProcedureLineNumber/vbaCodeCodeAddIn/cWhereAreWe/986/4
No Comments
530 Component/vbaCodeCodeAddIn/cWhereAreWe/990/4
No Comments
531 Project/vbaCodeCodeAddIn/cWhereAreWe/994/4
No Comments
532 CodePane/vbaCodeCodeAddIn/cWhereAreWe/998/4
No Comments
533 CodeModule/vbaCodeCodeAddIn/cWhereAreWe/1002/4
No Comments
534 UniqueProjectName/vbaCodeCodeAddIn/cWhereAreWe/1006/4
No Comments
535 ModuleDeclarationLines/vbaCodeCodeAddIn/cWhereAreWe/1010/4
No Comments
536 ProjectFileName/vbaCodeCodeAddIn/cWhereAreWe/1014/4
No Comments
537 SelectionArray/vbaCodeCodeAddIn/cWhereAreWe/1018/4
No Comments
538 Selection/vbaCodeCodeAddIn/cWhereAreWe/1022/4
No Comments
539 Scope/vbaCodeCodeAddIn/cWhereAreWe/1026/4
No Comments
540 ProjectName/vbaCodeCodeAddIn/cWhereAreWe/1030/4
No Comments
541 ProcedureName/vbaCodeCodeAddIn/cWhereAreWe/1034/4
No Comments
542 ModuleName/vbaCodeCodeAddIn/cWhereAreWe/1038/4
No Comments
543 Lines/vbaCodeCodeAddIn/cWhereAreWe/1042/4
No Comments
544 LineArray/vbaCodeCodeAddIn/cWhereAreWe/1046/4
No Comments
545 Line/vbaCodeCodeAddIn/cWhereAreWe/1050/4
No Comments
546 DimListN/vbaCodeCodeAddIn/cWhereAreWe/1054/4
No Comments
547 DimList/vbaCodeCodeAddIn/cWhereAreWe/1058/4
No Comments
548 CurrentLine/vbaCodeCodeAddIn/cWhereAreWe/1062/4
No Comments
549 CodeArray/vbaCodeCodeAddIn/cWhereAreWe/1066/4
No Comments
550 ProcType/vbaCodeCodeAddIn/cWhereAreWe/1070/4
No Comments
551 SLine/vbaCodeCodeAddIn/cWhereAreWe/1074/4
No Comments
552 SCol/vbaCodeCodeAddIn/cWhereAreWe/1078/4
No Comments
553 ProcStartLine/vbaCodeCodeAddIn/cWhereAreWe/1082/4
No Comments
554 ProcCountLines/vbaCodeCodeAddIn/cWhereAreWe/1086/4
No Comments
555 ProcBodyLine/vbaCodeCodeAddIn/cWhereAreWe/1090/4
No Comments
556 ModuleEndLine/vbaCodeCodeAddIn/cWhereAreWe/1094/4
No Comments
557 ELine/vbaCodeCodeAddIn/cWhereAreWe/1098/4
No Comments
558 ECol/vbaCodeCodeAddIn/cWhereAreWe/1102/4
No Comments
559 TotalComments/vbaCodeCodeAddIn/cWhereAreWe/1106/4
No Comments
560 ArrayStartOfDims/vbaCodeCodeAddIn/cWhereAreWe/1110/4
No Comments
561 SpaceLines/vbaCodeCodeAddIn/cWhereAreWe/1114/4
No Comments
562 ProcHeaderCodeArrayLine/vbaCodeCodeAddIn/cWhereAreWe/1118/4
No Comments
563 NumberOfParameters/vbaCodeCodeAddIn/cWhereAreWe/1122/4
No Comments
564 NumberOfHeaderCommentLines/vbaCodeCodeAddIn/cWhereAreWe/1126/4
No Comments
565 NumberOfCodeLines/vbaCodeCodeAddIn/cWhereAreWe/1130/4
No Comments
566 N/vbaCodeCodeAddIn/cWhereAreWe/1134/4
No Comments
567 ArrayEndOfHeader/vbaCodeCodeAddIn/cWhereAreWe/1138/4
No Comments
568 ArrayEndOfDims/vbaCodeCodeAddIn/cWhereAreWe/1142/4
No Comments
569 DimCountA/vbaCodeCodeAddIn/cWhereAreWe/1146/4
No Comments
570 DimCount/vbaCodeCodeAddIn/cWhereAreWe/1150/4
No Comments
571 CommentPos/vbaCodeCodeAddIn/cWhereAreWe/1154/4
No Comments
572 CodeLines/vbaCodeCodeAddIn/cWhereAreWe/1158/4
No Comments
573 ArrayStartOfCode/vbaCodeCodeAddIn/cWhereAreWe/1162/4
No Comments
574 ArrayProcBodyLine/vbaCodeCodeAddIn/cWhereAreWe/1166/4
No Comments
575 subPrintArray/vbaCodeCodeAddIn/zmPrintArray/2/185
Print an array of strings to a text file.
I wrote this because I found myself writing something
similar more than a few times!
576 subtestPrintArray/vbaCodeCodeAddIn/zmPrintArray/187/53
No Comments
577 subtestfrmInputBox/vbaCodeCodeAddIn/zmInputBox/2/11
No Comments
578 fncInputBox/vbaCodeCodeAddIn/zmInputBox/13/40
No Comments
579 fncRealInputBox/vbaCodeCodeAddIn/zmInputBox/53/22
No Comments
580 cmdCancel_Click/vbaCodeCodeAddIn/frmInputBox/16/10
No Comments
581 cmdOK_Click/vbaCodeCodeAddIn/frmInputBox/26/5
No Comments
582 cmdOK_KeyPress/vbaCodeCodeAddIn/frmInputBox/31/6
No Comments
583 UserForm_Initialize/vbaCodeCodeAddIn/frmInputBox/37/10
No Comments
584 subMakeParent/vbaCodeCodeAddIn/frmInputBox/47/37
No Comments
585 UserForm_QueryClose/vbaCodeCodeAddIn/frmInputBox/84/9
No Comments
586 UserForm_Terminate/vbaCodeCodeAddIn/frmInputBox/93/8
No Comments
587 Answer/vbaCodeCodeAddIn/frmInputBox/101/5
No Comments
588 Answer/vbaCodeCodeAddIn/frmInputBox/106/5
No Comments
589 Question/vbaCodeCodeAddIn/frmInputBox/111/4
No Comments
590 Title/vbaCodeCodeAddIn/frmInputBox/115/5
No Comments
591 Root/vbaCodeCodeAddIn/cRegOp/188/17
Don't accept an invalid Root value.
592 Key/vbaCodeCodeAddIn/cRegOp/205/12
Don't accept an empty key name.
593 Options/vbaCodeCodeAddIn/cRegOp/217/7
Don't accept an invalid Options value.
594 Value/vbaCodeCodeAddIn/cRegOp/224/66
No Comments
595 Value/vbaCodeCodeAddIn/cRegOp/290/6
No Comments
596 AllValues/vbaCodeCodeAddIn/cRegOp/296/20
No Comments
597 AllKeys/vbaCodeCodeAddIn/cRegOp/316/16
No Comments
598 DeleteValue/vbaCodeCodeAddIn/cRegOp/332/13
No Comments
599 DeleteKey/vbaCodeCodeAddIn/cRegOp/345/29
No Comments
600 ValueCount/vbaCodeCodeAddIn/cRegOp/374/3
No Comments
601 KeyCount/vbaCodeCodeAddIn/cRegOp/377/3
No Comments
602 PropertiesOK/vbaCodeCodeAddIn/cRegOp/380/17
No Comments
603 Class_Initialize/vbaCodeCodeAddIn/cRegOp/397/12
No Comments
604 Class_Terminate/vbaCodeCodeAddIn/cRegOp/409/4
No Comments
605 CloseCurrentKey/vbaCodeCodeAddIn/cRegOp/413/6
No Comments
606 GetKeyHandle/vbaCodeCodeAddIn/cRegOp/419/14
No Comments
607 TrimNull/vbaCodeCodeAddIn/cRegOp/433/3
No Comments
608 TrimDoubleNull/vbaCodeCodeAddIn/cRegOp/436/5
No Comments
609 ExpandString/vbaCodeCodeAddIn/cRegOp/441/7
No Comments
610 ShlwapiInstalled/vbaCodeCodeAddIn/cRegOp/448/8
No Comments
611 ContainsEnvString/vbaCodeCodeAddIn/cRegOp/456/26
No Comments
612 ShowErrMsg/vbaCodeCodeAddIn/cRegOp/482/7
No Comments
613 IsWinNT/vbaCodeCodeAddIn/cRegOp/489/8
Returns True if the OS is Windows NT/2000.
614 FillDataList/vbaCodeCodeAddIn/cRegOp/497/55
No Comments
615 Class_Initialize/vbaCodeCodeAddIn/cShortWhereAreWe/13/36
No Comments
616 ProjectName/vbaCodeCodeAddIn/cShortWhereAreWe/49/4
No Comments
617 ProjectFileName/vbaCodeCodeAddIn/cShortWhereAreWe/53/4
No Comments
618 StartCol/vbaCodeCodeAddIn/cShortWhereAreWe/57/4
No Comments
619 StartLine/vbaCodeCodeAddIn/cShortWhereAreWe/61/4
No Comments
620 EndLine/vbaCodeCodeAddIn/cShortWhereAreWe/65/4
No Comments
621 EndCol/vbaCodeCodeAddIn/cShortWhereAreWe/69/4
No Comments
622 ModuleName/vbaCodeCodeAddIn/cShortWhereAreWe/73/4
No Comments
623 UniqueProjectName/vbaCodeCodeAddIn/cShortWhereAreWe/77/4
No Comments
624 ProcedureName/vbaCodeCodeAddIn/cShortWhereAreWe/81/5
No Comments
625 subInsertGetProperty/vbaCodeCodeAddIn/mInsertProperties/2/160
Insert properties at the end of the
module for all Dims in a procedure.
626 CommandButton1_Click/vbaCodeCodeAddIn/UserForm1/2/14
No Comments
627 Label1_Click/vbaCodeCodeAddIn/UserForm1/16/4
No Comments
628 Label1_DblClick/vbaCodeCodeAddIn/UserForm1/20/4
No Comments
629 Class_Initialize/vbaCodeCodeAddIn/CHiResTimer/41/17
No Comments
630 StartTimer/vbaCodeCodeAddIn/CHiResTimer/58/5
Get the time that we started
631 StopTimer/vbaCodeCodeAddIn/CHiResTimer/63/5
Get the time that we stopped
632 Elapsed/vbaCodeCodeAddIn/CHiResTimer/68/18
No Comments
633 cmdCancel_Click/vbaCodeCodeAddIn/frmEditSelection/11/63
No Comments
634 cmdGetSelection_Click/vbaCodeCodeAddIn/frmEditSelection/74/44
No Comments
635 cmdRunEditSelection_Click/vbaCodeCodeAddIn/frmEditSelection/118/61
No Comments
636 cmdUpdateEditSelection_Click/vbaCodeCodeAddIn/frmEditSelection/179/50
No Comments
637 UserForm_Initialize/vbaCodeCodeAddIn/frmEditSelection/229/18
No Comments
638 subMakeParent/vbaCodeCodeAddIn/frmEditSelection/247/37
No Comments
639 UserForm_Terminate/vbaCodeCodeAddIn/frmEditSelection/284/10
No Comments
640 subtestfrmBrowseForProcedure/vbaCodeCodeAddIn/zmBrowseForProcedure/2/9
No Comments
641 fncGetCode/vbaCodeCodeAddIn/zmBrowseForProcedure/11/15
No Comments
642 cmdCancel_Click/vbaCodeCodeAddIn/frmBrowseForProcedure/14/12
No Comments
643 cmdOK_Click/vbaCodeCodeAddIn/frmBrowseForProcedure/26/5
No Comments
644 lstProcList_Click/vbaCodeCodeAddIn/frmBrowseForProcedure/31/54
No Comments
645 UserForm_Initialize/vbaCodeCodeAddIn/frmBrowseForProcedure/85/44
646 subMakeParent/vbaCodeCodeAddIn/frmBrowseForProcedure/129/37
No Comments
647 UserForm_QueryClose/vbaCodeCodeAddIn/frmBrowseForProcedure/166/9
No Comments
648 UserForm_Terminate/vbaCodeCodeAddIn/frmBrowseForProcedure/175/8
No Comments
649 Answer/vbaCodeCodeAddIn/frmBrowseForProcedure/183/5
No Comments
650 Answer/vbaCodeCodeAddIn/frmBrowseForProcedure/188/7
No Comments
651 subMakeParent/vbaCodeCodeAddIn/frmArrangeMacroMenu/11/53
No Comments
652 cmdCancel_Click/vbaCodeCodeAddIn/frmArrangeMacroMenu/64/4
No Comments
653 cmdOK_Click/vbaCodeCodeAddIn/frmArrangeMacroMenu/68/147
If it's in aamTopOfMacros get the code
and put it in an array.
If it's in aamTopOfMacros wipe it.
If it's NOT in aamTopOfMacros build
code and put it in the array.
Make sure aamTopOfMacros is empty.
Add all the code.
654 cmdAdd_Click/vbaCodeCodeAddIn/frmArrangeMacroMenu/215/33
No Comments
655 cmdRemove_Click/vbaCodeCodeAddIn/frmArrangeMacroMenu/248/33
No Comments
656 cmdBottom_Click/vbaCodeCodeAddIn/frmArrangeMacroMenu/281/6
No Comments
657 cmdTop_Click/vbaCodeCodeAddIn/frmArrangeMacroMenu/287/6
No Comments
658 cmdDown_Click/vbaCodeCodeAddIn/frmArrangeMacroMenu/293/6
No Comments
659 cmdUp_Click/vbaCodeCodeAddIn/frmArrangeMacroMenu/299/6
No Comments
660 subMoveListBoxItem/vbaCodeCodeAddIn/frmArrangeMacroMenu/305/81
No Comments
661 cmdPreview_Click/vbaCodeCodeAddIn/frmArrangeMacroMenu/386/47
No Comments
662 lstCCProcs_DblClick/vbaCodeCodeAddIn/frmArrangeMacroMenu/433/4
No Comments
663 lstTopOfMacroMenu_DblClick/vbaCodeCodeAddIn/frmArrangeMacroMenu/437/4
No Comments
664 UserForm_Terminate/vbaCodeCodeAddIn/frmArrangeMacroMenu/441/8
No Comments
665 UserForm_Initialize/vbaCodeCodeAddIn/frmArrangeMacroMenu/449/165
No Comments
666 fncIsShiftKeyDown/vbaCodeCodeAddIn/zmChipPearson/79/39
'''''''''''''''''''''''''''''''''''''''''''''''
IsShiftKeyDown
Returns TRUE or FALSE indicating whether the
SHIFT key is down.
667 fncIsControlKeyDown/vbaCodeCodeAddIn/zmChipPearson/118/34
'''''''''''''''''''''''''''''''''''''''''''''''
IsControlKeyDown
Returns TRUE or FALSE indicating whether the
CTRL key is down.
668 fncIsAltKeyDown/vbaCodeCodeAddIn/zmChipPearson/152/34
'''''''''''''''''''''''''''''''''''''''''''''''
IsAltKeyDown
Returns TRUE or FALSE indicating whether the
ALT key is down.
669 subtest/vbaCodeCodeAddIn/zmChipPearson/186/17
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Test
This is a procedure to test and demonstrate the Key-State
functions above. Since you can't run a macro in the VBA
Editor if the SHIFT, ALT, or CTRL key is down, this procedure
uses OnTime to execute the ProcTest test procedure. OnTime
will call ProcTest two seconds after running this Test
procedure. Immediately after executing Test, press the
key(s) (Left/Right SHIFT, ALT, or CTRL) you want to test
for. The procedure called by OnTime, ProcTest, displays the
status of the Left/Right SHIFT, ALT, and CTRL keys.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
670 subProcTest/vbaCodeCodeAddIn/zmChipPearson/203/22
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
ProcTest
This procedure simply displays the status of the Left adn Right
SHIFT, ALT, and CTRL keys.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
671 subDeleteProcedureFromModule/vbaCodeCodeAddIn/zmChipPearson/225/23
EXAMPLE!!
672 subDeleteModuleFromActiveVBProject/vbaCodeCodeAddIn/zmChipPearson/248/22
Delete a module.
Almost Chip.
673 subAddModuleToActiveVBProject/vbaCodeCodeAddIn/zmChipPearson/270/18
Almost Chip.
674 subAddProcedureToModuleInActiveVBProject/vbaCodeCodeAddIn/zmChipPearson/288/38
Chip.
675 fncIsArrayAllocated/vbaCodeCodeAddIn/zmChipPearson/326/52
Chip Pearson.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
IsArrayAllocated
Returns TRUE if the array is allocated (either a static array or a dynamic array that has been
sized with Redim) or FALSE if the array is not allocated (a dynamic that has not yet
been sized with Redim, or a dynamic array that has been Erased). Static arrays are always
allocated.
676 subAddVBERef/vbaCodeCodeAddIn/zmChipPearson/378/9
Chip.
677 subSyncVBAEditor/vbaCodeCodeAddIn/zmChipPearson/387/15
Chip.
=======================================================================
SyncVBAEditor
This syncs the editor with respect to the ActiveVBProject and the
VBProject containing the ActiveCodePane. This makes the project
that conrains the ActiveCodePane the ActiveVBProject.
=======================================================================
678 subShowLibraryPath/vbaCodeCodeAddIn/zmChipPearson/402/9
Chip.
679 fncExportVBComponent/vbaCodeCodeAddIn/zmChipPearson/411/45
Chip.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
This function exports the code module of a VBComponent to a text
file. If spFileName is missing, the code will be exported to
a file with the same name as the VBComponent followed by the
appropriate extension.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
680 fncGetFileExtension/vbaCodeCodeAddIn/zmChipPearson/456/22
Chip.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
This returns the appropriate file extension based on the Type of
the VBComponent.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
681 fncCopyModule/vbaCodeCodeAddIn/zmChipPearson/478/160
Chip.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
CopyModule
This function copies a module from one VBProject to
another. It returns True if successful or False
if an error occurs.
682 fncWorkbookOfVBProject/vbaCodeCodeAddIn/zmChipPearson/638/63
### This should not be used.
I've incorrectly used this to return the project
filename... but want the filename
of the office application document rather than the WORKBOOK
filename.
683 fncIsArrayEmpty/vbaCodeCodeAddIn/zmChipPearson/701/3
No Comments
684 fncDataTypeOfArray/vbaCodeCodeAddIn/zmChipPearson/704/82
Chip.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
DataTypeOfArray
685 fncNumberOfArrayDimensions/vbaCodeCodeAddIn/zmChipPearson/786/22
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
NumberOfArrayDimensions
This function returns the number of dimensions of an array. An unallocated dynamic array
has 0 dimensions. This condition can also be tested with IsArrayEmpty.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
686 fncCreateHTMLReport/vbaCodeCodeAddIn/mHTMLReport/2/235
No Comments
687 fncGetHiResTimerClass/vbaCodeCodeAddIn/mInstantiateClasses/2/10
No Comments
688 UserForm_Initialize/vbaCodeCodeAddIn/frmBlankFormForTheVBE/12/11
No Comments
689 subMakeParent/vbaCodeCodeAddIn/frmBlankFormForTheVBE/23/38
No Comments
690 UserForm_Terminate/vbaCodeCodeAddIn/frmBlankFormForTheVBE/61/9
No Comments
691 A_subccArrangeMacros/vbaCodeCodeAddIn/aamTopOfMacros/2/5
No Comments
692 A_subccCodeCodeForm/vbaCodeCodeAddIn/aamTopOfMacros/7/4
No Comments
693 A_subccShutDown/vbaCodeCodeAddIn/aamTopOfMacros/11/4
No Comments
694 AA_subccBackMeUp/vbaCodeCodeAddIn/aamTopOfMacros/15/4
No Comments
695 AB_subccDeleteDebugCode/vbaCodeCodeAddIn/aamTopOfMacros/19/4
No Comments
696 AC_subccGoToBottomOfDims/vbaCodeCodeAddIn/aamTopOfMacros/23/4
No Comments
697 AD_subccInsertDims/vbaCodeCodeAddIn/aamTopOfMacros/27/4
No Comments
698 AE_subccCleanProcedure/vbaCodeCodeAddIn/aamTopOfMacros/31/4
No Comments
699 AF_subccXRefProcedure/vbaCodeCodeAddIn/aamTopOfMacros/35/4
No Comments
700 AG_subccInsertSelectionDebug/vbaCodeCodeAddIn/aamTopOfMacros/39/4
No Comments
701 AH_subccInsertErrorCodeAtLine/vbaCodeCodeAddIn/aamTopOfMacros/43/4
No Comments
702 AI_subccSortDims/vbaCodeCodeAddIn/aamTopOfMacros/47/4
No Comments
703 AJ_subccSmartIndent/vbaCodeCodeAddIn/aamTopOfMacros/51/4
No Comments
704 AK_subccDeleteInBetweenLines/vbaCodeCodeAddIn/aamTopOfMacros/55/4
No Comments
705 AL_subccInsertComments/vbaCodeCodeAddIn/aamTopOfMacros/59/4
No Comments
706 AM_subccRemoveEndOfLineComment/vbaCodeCodeAddIn/aamTopOfMacros/63/4
No Comments
707 subChangeIntegersToLong/vbaCodeCodeAddIn/mChangeIntegersToLong/2/131
Change Integer to long.
Using a naming convention makes this a
non trivial task.
This will alter the definition and
the prefix as well.
708 fncStripPrefix/vbaCodeCodeAddIn/mChangeIntegersToLong/133/27
No Comments
709 fncGetUniqueProject/vbaCodeCodeAddIn/cWhereAreWe2/90/45
Return ProjectName(Project FileName) as seen
in the project explorer given a project
object.
710 fncIsArrayAllocated/vbaCodeCodeAddIn/cWhereAreWe2/135/49
Chip Pearson.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
IsArrayAllocated
Returns TRUE if the array is allocated (either a static array or a dynamic array that has been
sized with Redim) or FALSE if the array is not allocated (a dynamic that has not yet
been sized with Redim, or a dynamic array that has been Erased). Static arrays are always
allocated.
711 fncJoinLines/vbaCodeCodeAddIn/cWhereAreWe2/184/108
NON Recursively Join up the lines that have underscores at the end.
Return the Line.
Go back up if we are in the middle of a continuation line set.
Optionally leave the underscores in or remove them.
Default is to remove them.
Strip EOL comment.
712 fncGetParameters/vbaCodeCodeAddIn/cWhereAreWe2/292/59
Return an array of parameters given a CodeArray.
### Note that if there are no parameters an unallocated
array is returned.
The header line number is passed because we probably
have it already.
713 Class_Initialize/vbaCodeCodeAddIn/cWhereAreWe2/351/705
No Comments
714 ProjectName/vbaCodeCodeAddIn/cWhereAreWe2/1056/4
No Comments
715 ModuleName/vbaCodeCodeAddIn/cWhereAreWe2/1060/4
No Comments
716 ProcedureName/vbaCodeCodeAddIn/cWhereAreWe2/1064/4
No Comments
717 ProjectFileName/vbaCodeCodeAddIn/cWhereAreWe2/1068/4
No Comments
718 UniqueProjectName/vbaCodeCodeAddIn/cWhereAreWe2/1072/4
No Comments
719 ProcedureScopeText/vbaCodeCodeAddIn/cWhereAreWe2/1076/4
No Comments
720 CurrentLineText/vbaCodeCodeAddIn/cWhereAreWe2/1080/4
No Comments
721 ModuleStartLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1084/4
No Comments
722 ModuleSubLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1088/4
No Comments
723 ModuleEndofHeaderLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1092/4
No Comments
724 ModuleEndHeaderLineP1Num/vbaCodeCodeAddIn/cWhereAreWe2/1096/4
No Comments
725 ModuleSpaceLineAfterHeaderNum/vbaCodeCodeAddIn/cWhereAreWe2/1100/4
No Comments
726 ModuleInsertDimsAtLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1104/4
No Comments
727 ModuleAfterHeaderCommentsSpaceLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1108/4
No Comments
728 ModuleSpaceLineBeforeDimsNum/vbaCodeCodeAddIn/cWhereAreWe2/1112/4
No Comments
729 ModuleStartDimsLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1116/4
No Comments
730 ModuleEndDimsLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1120/4
No Comments
731 ModuleEndofDimsLineP1Num/vbaCodeCodeAddIn/cWhereAreWe2/1124/4
No Comments
732 ModuleSpaceLineAfterDimsNum/vbaCodeCodeAddIn/cWhereAreWe2/1128/4
No Comments
733 ModuleStartofCodeLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1132/4
No Comments
734 ModuleEndStarLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1136/4
No Comments
735 ModuleSubEndLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1140/4
No Comments
736 CurrentModuleLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1144/4
No Comments
737 ModuleEndProcedureLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1148/4
No Comments
738 ModuleFirstNonconsecutiveDimLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1152/4
No Comments
739 ModuleEndLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1156/4
No Comments
740 NumModuleDecLines/vbaCodeCodeAddIn/cWhereAreWe2/1160/4
No Comments
741 ModuleEndOfDeclarationsLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1164/4
No Comments
742 ModuleTypeNum/vbaCodeCodeAddIn/cWhereAreWe2/1168/4
No Comments
743 ArraySubLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1172/4
No Comments
744 ArrayEndofHeaderLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1176/4
No Comments
745 ArrayEndOfHeaderP1Num/vbaCodeCodeAddIn/cWhereAreWe2/1180/4
No Comments
746 ArraySpaceLineAfterHeaderNum/vbaCodeCodeAddIn/cWhereAreWe2/1184/4
No Comments
747 ArrayInsertDimsAtLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1188/4
No Comments
748 ArrayAfterHeaderCommentsSpaceLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1192/4
No Comments
749 ArraySpaceLineBeforeDimsNum/vbaCodeCodeAddIn/cWhereAreWe2/1196/4
No Comments
750 ArrayStartOfDimsLine/vbaCodeCodeAddIn/cWhereAreWe2/1200/4
No Comments
751 ArrayEndDimsLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1204/4
No Comments
752 ArrayEndOfDimsLineP1Num/vbaCodeCodeAddIn/cWhereAreWe2/1208/4
No Comments
753 ArraySpaceLineAfterDimsNum/vbaCodeCodeAddIn/cWhereAreWe2/1212/4
No Comments
754 ArrayStartOfCodeLine/vbaCodeCodeAddIn/cWhereAreWe2/1216/4
No Comments
755 ArrayEndStarLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1220/4
No Comments
756 ArraySubEndLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1224/4
No Comments
757 CurrentArrayLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1228/4
No Comments
758 ArrayEndProcedureLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1232/4
No Comments
759 ArrayFirstNonconsecutiveDimLineNum/vbaCodeCodeAddIn/cWhereAreWe2/1236/4
No Comments
760 NumberOfSelectionLines/vbaCodeCodeAddIn/cWhereAreWe2/1240/4
No Comments
761 ModuleSelectionStartLine/vbaCodeCodeAddIn/cWhereAreWe2/1244/4
No Comments
762 ModuleSelectionStartCol/vbaCodeCodeAddIn/cWhereAreWe2/1248/4
No Comments
763 ModuleSelectionEndLine/vbaCodeCodeAddIn/cWhereAreWe2/1252/4
No Comments
764 ModuleSelectionEndCol/vbaCodeCodeAddIn/cWhereAreWe2/1256/4
No Comments
765 SelectionText/vbaCodeCodeAddIn/cWhereAreWe2/1260/4
No Comments
766 NumOfProcedureLines/vbaCodeCodeAddIn/cWhereAreWe2/1264/4
No Comments
767 NumOfSpaceLines/vbaCodeCodeAddIn/cWhereAreWe2/1268/4
No Comments
768 NumBeforeSubComments/vbaCodeCodeAddIn/cWhereAreWe2/1272/4
No Comments
769 NumOfHeaderComments/vbaCodeCodeAddIn/cWhereAreWe2/1276/4
No Comments
770 NumOfProcBodyComments/vbaCodeCodeAddIn/cWhereAreWe2/1280/4
No Comments
771 TotalNumOfCommentLines/vbaCodeCodeAddIn/cWhereAreWe2/1284/4
No Comments
772 NumOfCodeLines/vbaCodeCodeAddIn/cWhereAreWe2/1288/4
No Comments
773 NumOfIfLines/vbaCodeCodeAddIn/cWhereAreWe2/1292/4
No Comments
774 NumOfForNextLoops/vbaCodeCodeAddIn/cWhereAreWe2/1296/4
No Comments
775 NumOfDoLoops/vbaCodeCodeAddIn/cWhereAreWe2/1300/4
No Comments
776 NumOfElseIfLines/vbaCodeCodeAddIn/cWhereAreWe2/1304/4
No Comments
777 NumOfSelectCaseLines/vbaCodeCodeAddIn/cWhereAreWe2/1308/4
No Comments
778 NumOfCaseLines/vbaCodeCodeAddIn/cWhereAreWe2/1312/4
No Comments
779 NumOfWhileWendLoops/vbaCodeCodeAddIn/cWhereAreWe2/1316/4
No Comments
780 NumOfExitSubLines/vbaCodeCodeAddIn/cWhereAreWe2/1320/4
No Comments
781 NumOfExitDoLines/vbaCodeCodeAddIn/cWhereAreWe2/1324/4
No Comments
782 NumOfExitForLines/vbaCodeCodeAddIn/cWhereAreWe2/1328/4
No Comments
783 NumOfAndStatements/vbaCodeCodeAddIn/cWhereAreWe2/1332/4
No Comments
784 NumOfOrStatements/vbaCodeCodeAddIn/cWhereAreWe2/1336/4
No Comments
785 NumOfPlusOps/vbaCodeCodeAddIn/cWhereAreWe2/1340/4
No Comments
786 NumOfMinOps/vbaCodeCodeAddIn/cWhereAreWe2/1344/4
No Comments
787 NumOfDivOps/vbaCodeCodeAddIn/cWhereAreWe2/1348/4
No Comments
788 NumOfMplyOps/vbaCodeCodeAddIn/cWhereAreWe2/1352/4
No Comments
789 NumOfParameters/vbaCodeCodeAddIn/cWhereAreWe2/1356/4
No Comments
790 NumOfDims/vbaCodeCodeAddIn/cWhereAreWe2/1360/4
No Comments
791 ProcedureTypeNum/vbaCodeCodeAddIn/cWhereAreWe2/1364/4
No Comments
792 Component/vbaCodeCodeAddIn/cWhereAreWe2/1368/4
No Comments
793 Project/vbaCodeCodeAddIn/cWhereAreWe2/1372/4
No Comments
794 CodePane/vbaCodeCodeAddIn/cWhereAreWe2/1376/4
No Comments
795 CodeModule/vbaCodeCodeAddIn/cWhereAreWe2/1380/4
No Comments
796 fncGetPrefix/vbaCodeCodeAddIn/mKeyWord/3/86
Return the lowercase prefix if a variable.
Assumes a naming Convention of...
prefixAaaaaAaaaa
Lower case prefix for type and scope.
Meaningful name with Uppercase Lower Case parts.
eg ilNumberOfCodeLines
i = Integer l = Local Number Of Code Lines.
797 fncGetUniqueProject/vbaCodeCodeAddIn/mKeyWord/89/26
Return ProjectName(Project FileName) as seen
in the project explorer given a project
object.
798 fncProjectExists/vbaCodeCodeAddIn/mKeyWord/115/40
Does the project exist?
Loop through the projects.
799 fncIsLower/vbaCodeCodeAddIn/mKeyWord/155/13
Return True if parameter is LOWER case.
800 fncStripNonAlpha/vbaCodeCodeAddIn/mKeyWord/168/58
Delete non alpha chrs.
Originally built for testing for KeyWords.
801 fncIsKW/vbaCodeCodeAddIn/mKeyWord/226/248
### There is a VERY significant overhead to do
this so I'm going to use a dual approach in
that testing for the common ones first and
only test for others if not found.
See fncIsKeyWordL.
802 fncIsInKeyWordList/vbaCodeCodeAddIn/mKeyWord/474/57
Return True if found in a keyword LIST.
THis is pretty useless in some ways as the list
is **VERY** long and being altered with every version.
BUT.. it does shorten the path for most of the common ones.
803 fncGetKeyWordList/vbaCodeCodeAddIn/mKeyWord/531/100
No Comments
804 subSaveOrigonalKeyWordList/vbaCodeCodeAddIn/mKeyWord/631/172
See the notes at the top of the zmINI module or the end of the INI file.
Each line in an INI file cannot be more than 2045 characters in length.
The ORIGINAL list is hard coded here but could come from anywhere.
805 subAddToKeyWordList/vbaCodeCodeAddIn/mKeyWord/803/75
No Comments
806 subccInsertModuleLineNumbers/vbaCodeCodeAddIn/mInsertModuleLineNumbers/2/93
BATCH.